This blog is a knowledge base...where I clip cool tricks and urls

ORM by Urielka

clipped from

  • transactions - used inside GearsORM itself

  • self relations(i.e. a relation to the same table/model) - very useful when working with Tree-like structures in the database

  • count method - so now u can do Person.count() instead of

The most important update in this version is of course transaction support.
SQLite is known for really bad write preformence when not working with transactions.
While developing transaction support for GearsORM i had to write a test,in that test it execute 100 inserts and 100 updates,this test take about 15 seconds for the inserts and about 10 seconds for the updates without transactions,when using transactions for each set it takes about 377ms for the inserts and 200ms for the updates that is about 39 times faster!

 blog it

No comments: