I've spent the last days optimizing GyroGeas for application with heavy data. I've tested MySQL, Firebird and PostgreSQL with databases of at least 500,000 random records. I was impressed by PostgreSQL (being surprisingly fast). On the worst case query, MySQL 5 executed a select (with indexes) in about 14 seconds, Firebird 2.5, in about 20 seconds and PostgreSQL 8.4 in less than 8 seconds. The average query took about 1 second. Firebird was very slow on executing SELECT COUNT()... GROUP BY statements. Except that, overall performance is relatively good for all of the three engines.
New features in Concept Client:
Windows notify using the tray balloon
Combo edit box with progress bar on background for pagination (progress bar shows current page/total pages fraction)
GyroGears now generates all the required indexes for the generated database. I've optimized all the queries and the speed was enhanced.