U++ framework: Coffee corner » Database performance test

Home » Community » Coffee corner » Database performance test

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database performance test [message #11505]

Sun, 16 September 2007 03:40

Novo
Messages: 1433
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 513 times)

Regards,
Novo

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

Report message to a moderator

[Message index]

		Database performance test By: Novo on Sun, 16 September 2007 03:40
		Re: Database performance test By: zsolt on Sun, 16 September 2007 22:14
		Re: Database performance test By: Novo on Mon, 17 September 2007 02:36

Previous Topic:	NTL - "deep copy semantics"?
Next Topic:	Vista vs XP - building theide

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 23 00:47:34 GMT+2 2026

Total time taken to generate the page: 0.00481 seconds