Today: October 23, 2018, 4:37 am
Computer & Technology

When SQLite hits the wall, multithreaded DBMS are ready to resolve the performance botteneck. 2018-05-04 16:58:40
SQLite is one of the most popular database management systems out there and with good reason. However, we can’t overlook the fact that there is a significant loss in performance when there are multiple users of the database writing at the same time.

With over a trillion SQLite databases deployed, millions of application owners are forced to look for alternative embedded databases like Raima Database Manager to resolve their performance bottleneck.

In this test we explain why users run into the performance bottlenecks and alternative options to overcome them.

The test is based on a standard TPC-B test framework that measures throughput in terms of how many transactions per second the system can perform.

Find the test here and learn how to overcome low performance in database management.

The majority of today’s operating system and hardware support multithreading. SQLite does not take advantage of this opportunity because of the design in SQLite. When there are many concurrent writes to a SQLite database, application users experience a significant reduction in speed and the application may not meet the users performance expectations. It is well known that the write access to the SQLite database can only be granted if no other requests are being serviced. It is the "one write at a time" design within SQLite that slows down the throughput. Thus, many application owners are forced to look for alternative embedded database options to resolve their performance bottleneck.

Raima has put together a test that proves the differences between the RDM database solution and SQLite. In this test, we demonstrate that RDM is a good alternative to SQLite.

How we did the test

In this performance comparison, we used a standard TPC-B  test framework from The TPC-B measures throughput in terms of how many transactions per second the system can perform. The test has been modified to allow for comparisons where multiple clients are doing parallel work.

We used the same test environment and framework for both SQLite and RDM. In the test, RDM proved to be significantly faster than SQLite.  See illustration below. The platform used for the test was RDM release 14.1 running against SQLite v3.23 on a standard Windows 10, Intel i7 processor machine with 16GB's of RAM and standard SATA hard drive.

RDM has a design that is optimized for embedded systems with a modern and efficient set of API's, along with a well-designed database storage file format. RDM allows for concurrent writes and reads and therefore can do many more times the amount of work that SQLite can do.

Press Information


Published by
Fredrik Sande

# 428 Words
Related Articles
More From Computer & Technology
Intellias Attracts Horizon Capital’s Backing
On September 28, 2018, Intellias, a leading IT services provider with operations in Ukraine, announced today that a Horizon Capital-managed [..]
Appinventiv’s App Development Strategies Left a Notable [..]
Appinventiv, with its unparalleled excellence in mobile app development, will soon rank among the top mobile app development companies [..]
Breakthrough In Accessing The Tiny Magnet Within [..]
BREAKTHROUGH IN ACCESSING THE TINY MAGNET WITHIN THE CORE OF A SINGLE ATOM New method enables identification of different isotopes [..]
ManageEngine Adds User Behavior Analytics to ADAudit [..]
ManageEngine, the real-time IT management company, today announced the addition of user behavior analytics (UBA) to ADAudit Plus, [..]
Thor Enterprise is Anti-Malware Solution of the [..]
Copenhagen, October 12, 2018 – The Computing Security Awards 2018, organized by one of the most influential and widely read [..]

Disclaimer: If you have any questions regarding information in this press release please contact the company added in the press release. Please do not contact pr-inside. We will not be able to assist you. PR-inside disclaims the content included in this release.