PR-Inside.com: 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 www.tpc.org. 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.