Saturday, September 25, 2010

New features and more testing

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.

No comments: