Who we are

We are the developers of Plastic SCM, a full version control stack (not a Git variant). We work on the strongest branching and merging you can find, and a core that doesn't cringe with huge binaries and repos. We also develop the GUIs, mergetools and everything needed to give you the full version control stack.

If you want to give it a try, download it from here.

We also code SemanticMerge, and the gmaster Git client.

Blob performance

Thursday, August 17, 2006 Pablo Santos 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
Inserting 10000 records95044025479738252674
Inserting 50 binary records (4Mb each)1388020380499411485296269
Reading 10000 records977427444917124582984
Reading 50 Binary records10295323410035492725026
Deleting all (non transacted)5307311435143111787

0 comentarios: