New Benchmark Comparison of ITTIA DB SQL and SQLite

30th March 2010

ITTIA

ES Admin

0 0

ITTIA, a global supplier of embedded lightweight relational database software, demonstrates its database benchmark leadership to application developers of embedded systems and devices, with exceptional results. On an ARM device, ITTIA DB SQL surpasses SQLite, an open source database, in three critical areas: insert, select, and update. ITTIA's flagship product, ITTIA DB SQL, is an industry-leading RDBMS that provides performance and reliability in embedded environments, from embedded Linux and Windows Mobile to desktop workstations.

In addition, ITTIA has released a white paper detailing the benchmark exercise and results. This paper explores the usage of both ITTIA DB SQL and SQLite, comparing both database technologies and showing how embedded developers are best served by selecting ITTIA DB SQL.

In this recent benchmark, ITTIA DB SQL outperforms SQLite in almost all cases. When writing to flash media on an ARM device, ITTIA DB SQL's write-ahead logging gives it a tremendous boost to throughput by minimizing I/O operations. When data is stored in memory tables, T-tree indexes and other optimizations cut the overhead of all database operations, giving applications a performance edge.

Applications embedded with ITTIA DB SQL can share data more easily between multiple tasks: in different threads, processes, or devices. Unlike the file-level locking used by SQLite, ITTIA DB's row-level locking allows different tasks to work concurrently on the same database. This is both safer than relying on the file system to prevent conflicts, and faster when several tasks share access to the same data. Static typing is another safety feature that is not available in SQLite, which allows data to be stored in an unexpected format by SQLite. ITTIA DB SQL also supports both SQL queries and low-level table cursors, which are used to avoid the overhead associated with SQL.

ITTIA DB SQL supports a dedicated memory storage option that is tuned for situations where data can fit completely in main memory. Whether data is stored in-memory or on-disk, the same queries and application code can be used to access the data. For memory tables, ITTIA DB uses special algorithms to optimize performance. SQLite uses the same paging algorithms that are designed for disk storage.

The new benchmark indicates a performance advantage from 29% to over 1,000% when application developers embed ITTIA DB SQL on a device as a superior alternative to SQLite, said Sasan Montaseri, ITTIA Founder and President. ITTIA is setting additional benchmark records against SQLite both for on-disk and in-memory data management, and our white paper details these results.