New Benchmark Comparison of ITTIA DB SQL and SQLite

contents

software

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 a 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 white paper "Performance Comparison – ITTIA DB and SQLite" is available on ITTIA's website.

write your comments about the article :: © 2010 Networking News :: home page