U++ forum: Welcome to the forum

Database performance test [message #11505]

Sun, 16 September 2007 03:40

Novo
Messages: 1358
Registered: December 2006

Ultimate Contributor

I'd like to post a simple database performance test, which is designed after http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison

It can be interesting for those who wants to compare performance and memory usage of different databases and database access technologies.

I've attached the test itself and four database drivers:
1) Firebird 1.5 (embedded);
2) MS JET ADO;
3) MS JET ODBC;
4) SQLITE (which is an embedded sql server);

A database for Firebird is also included.

Command lines to run:

perf_sdb_test.exe --conn_str="/SQLITE" --db_name=test.sqlite
perf_sdb_test.exe --conn_str="/SQLITE_EMB" --db_name=test.sqlite

perf_sdb_test.exe --conn_str="/ADO/Microsoft.Jet.OLEDB.4.0" --db_name=test.mdb
perf_sdb_test.exe --conn_str="/ODBC/Microsoft Access Driver (*.mdb)" --db_name=test.mdb

perf_sdb_test.exe --conn_str="/InterBase_EMB" --db_name=TEST01.FDB --user_name=test --user_passwd=test

This test also demonstrates that DLLs on Windows is not hell at all.

Have fun!

Attachment: perf_sdb_20070915.zip
(Size: 1.37MB, Downloaded 363 times)

Regards,
Novo

[Updated on: Sun, 30 September 2007 05:52]

Report message to a moderator