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
Transacted
Inserting 10000 records95044025479738252674
Inserting 50 binary records (4Mb each)1388020380499411485296269
Reading 10000 records977427444917124582984
Reading 50 Binary records10295323410035492725026
Deleting all (non transacted)5307311435143111787
Pablo Santos
I'm the CTO and Founder at Códice.
I've been leading Plastic SCM since 2005. My passion is helping teams work better through version control.
I had the opportunity to see teams from many different industries at work while I helped them improving their version control practices.
I really enjoy teaching (I've been a University professor for 6+ years) and sharing my experience in talks and articles.
And I love simple code. You can reach me at @psluaces.

Pablo Santos

0 comentarios:

Subscribe to: Post Comments (Atom)