October 21, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Performance Comparison - ITTIA DB and SQLite

  • March 15, 2010
  • By Developer.com Staff
  • Send Email »
  • More Articles »

ITTIA DB-SQL and SQLite are lightweight embedded relational databases used to manage information stored in applications and devices. ITTIA DB-SQL is a commercial product, while SQLite is in the public domain. In ITTIA's benchmark tests, ITTIA DB-SQL consistently outperformed SQLite on Linux PCs and devices, with dramatic differences in update and insert times. On Windows PCs, inserts and updates were faster with ITTIA DB-SQL, while select times were roughly the same.

Special features of ITTIA DB-SQL include: a write-ahead log for transactions; row-level locking; optimized paging algorithms for in-memory tables; hybrid in-memory/on-disk databases; static typing; low-level table cursors; and database encryption callbacks.

SQLite is suitable for simple projects, while ITTIA DB-SQL is recommended for advanced projects because of its performance-boosting features and commercial-grade support.






Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Sitemap | Contact Us

Rocket Fuel