Products

SQLBase® Embedded Database


What's New in SQLBase 11

Use SQLBase 11 to increase your transaction and reporting throughput significantly.
With SQLBase 11 you can have more concurrent users using SQLBase than ever before. You might well find that you do not need to switch to other databases for scalability reasons anymore. Internal TPC-C benchmark testing revealed a 2.6 times increase of transaction throughput in SQLBase 11 and a 7 times reporting acceleration. SQLBase 11 also features new auto increment columns for automated unique key generation. The SQLBase 11 automatic database update feature allows you to easily deploy the product to your installed base without the need of manual interaction to update the databases.

Reasons to Upgrade to SQLBase 11 Now!

 

SQLBase 11 TPC-C Benchmark: Write-access transactions up to 2.6 times faster, reports up to 7 times faster!

Think about what that performance increase can do for you! Your users will be amazed by the new application speed. You can have many more users accessing one SQLBase server than ever before. Switching to other database products for scalability reasons might not be necessary anymore. You can use the easy database features of SQLBase for hundreds of concurrent users now. The industry standard TPC-C benchmark test simulates a complete environment where a population of terminal operators executes transactions against a database. These transactions include entering and delivering orders, recording payments, checking the status of orders, and monitoring the level of stock at the warehouses (updates, inserts while running reports).
 

SQLBase 11 Transaction Throughput

SQLBase 11 can be described as live and let live. Writing transactions are not getting into the way of reading transactions and reading transactions do not get into the way of writing transactions allowing both to travel at much higher speeds. SQLBase 11 performs much better in transactions and reporting than SQLBase 9.0.1. All numbers are in transactions per minute. Enabling the SQLBase 11 Read Only isolation level results in hugely increased transaction throughput from 75 tpm in SQLBase 9.0.1 (RL mode) to 199 tpm in SQLBase 11 which is a strong 2.6 times improvement over SQLBase 9.0.1.
 

SQLBase 11 Reporting Performance

Enjoy a smooth reporting experience with SQLBase 11. Imagine a road with no red traffic lights and no speed limit. That is what SQLBase 11 does to your reports. Reports running on the TPC-C database increase from 209 tpm in SQLBase 9.0.1 (RL) to 1452 tpm in SQLBase 11 using Read Only isolation level. This is an almost 7 times performance increase for reporting solutions in SQLBase 11.
 

Row Level Locking Behavior

  • Reading transactions: New Read Committed and Read Only isolation levels do not run into locks when reading data
  • Writing transactions: New locking mechanisms and functionality have been added to SQLBase 11. The intention of the new locking functionality is to improve concurrency and throughput by reducing or eliminating lock contention including non-application deadlocks. This functionality includes “LOCK TABLE” and “SET AUTOLOCKTABLE” statements that can be prepared and executed as well as configuration settings in the sql.ini file. With AutoLockTable set to SMART non-application deadlocks will be eliminated.

Additional Features and Benefits of SQLBase 11

  • Easier application development and maintenance: SQLBase 11 features new Auto-Increment columns to allow for automatic unique key generation.
  • Easy database administration: Databases greater than 2 gigabytes can be backed up without segmentation.
  • Improved Java support for NXJ Developer and other Java tools like Eclipse The SQLBase 11 JDBC driver has been updated to support the JDK 1.4.1 as well as significant performance and functionality improvements.

Easy Upgrading and Deployment of SQLBase 11


No worries about upgrading many SQLBase installations to SQLBase 11. There is no need to do on site visits or remote admin activities to get SQLBase 11 up and running using existing databases. SQLBase 11 offers very easy deployment through automatic upgrade for SQLBase 7.5.1-9.0.1 databases upon first connect.