Blob performance

Thursday, August 17, 2006 0 Comments

Our SCM can use different database back-ends to store data. We have made some tests about database performance, basically measuring regular insert and read operations, and the same operations with BLOBs.

We tried with Firebird (both embedded and server), Postgres (7.2), SQL Server Express and MySQL. The resutls? Have a look at the following table and make your choice...




Non TransactedFirebird-ServerSQL Server Expr 05PostgresFirebird-embeddedMySQL
Inserting 10000 records205396489881313860292591
Inserting 50 binary records (4Mb each)1966836372472981926767727
Reading 10000 records1392027645789150423175
Reading 50 Binary records996521849914433616964
Transacted
Inserting 10000 records95044025479738252674
Inserting 50 binary records (4Mb each)1388020380499411485296269
Reading 10000 records977427444917124582984
Reading 50 Binary records10295323410035492725026
Deleting all (non transacted)5307311435143111787

0 comentarios: