VCL

Kylix

Download

Technologies

Articles

SQLMemTable v.4 - Even Faster!


	Products
Delphi Components

Accuracer

EasyTable

SQLMemTable

Single File System

CryptoPressStream

MsgCommunicator

Active Query Builder

Database Master

BDE Replacement

Delphi Database

Kylix Components

Download

Technologies

Articles

Under Development


	Order
How To Buy

Sales Policy

Upgrade Policy


	Support
Support Policy

FAQ

Contact Us


	Info
Main

News

Why Choose Us

Testimonials

Partners

About Us

Awards

Trademarks

Subscription

Database Designer - Easy Data Import

SQLMemTable v.4 - The Fastest Memory Database with SQL Support

SQLMemTable is the first and only memory database with SQL support for Delphi and C++ Builder. You can create as many memory databases as you like - each of them will have its own tables namespace. Thus it is possible to create multiple copies of same database - like snapshots. SQLMemTable can be used for importing data from different databases, as it allows to create fully independent databases - MemDBOracle for import from Oracle, MemDBMSSQL for SQL Server, MemDBMySQL for MySQL, etc.

Another great advantage of SQLMemTable - is its Database Designer. It allows to perform all possible operations - import data from any TDataset descendant, export to SQL, execute SQL scripts, save and load database, browse table and queries.
Shortly, Database Designer includes all features of SQLConsole utility and much more.

Performance comparison with v.3 - Load / Save

The results of first complex test in the Table1.
The performance advantage of version 4 is shown on the Diagram 1. Diagram 1. Test table with many fields and indexes - 20,000 records.
SQLMemTable - Delphi memory database speed tests

SQLMemTable - Delphi memory database speed tests

Table 1. Tests passing time for 20,000 records, sec.

Operation	v.3.90 time, sec.	v.4.00 time, sec.	v.4.00 advantage, times.
Create table	0.000	0.000	0.00
Insert records	3.891	3.750	1.04
Save table	253.781	0.078	3253.60
Delete table	0.000	0.000	0.00
Load table	0.032	0.032	1.00
Overall	257.704	3.860	66.76

Test environment: Intel Pentium 4 2.4 Ghz, 512 MB RAM, Windows XP SP2. You can download full source code of the testing program.
You may freely use and change this program but in any case with any publishing of any investigations using the materials presented here (including program(s) for measurements) or the measurement principles, you must needs refer to AidAim Software as the author and this article itself.

Performance comparison with v.3 - Insert

Try It Now For Free!!!

The results of insert test with simple table structure in the Table2.
The performance advantage of version 4 is shown on the Diagram 2.
Increasing the record size and number of records will lead to greater difference, as the version 4 of SQLMemTable has much better algorithm of memory management.

Diagram 2. Test table with simple structure - 1,000,000 records.
SQLMemTable - Delphi memory database speed tests

Table 2. Tests passing time for 1,000,000 records, sec.

Operation	v.3.90 time, sec.	v.4.00 time, sec.	v.4.00 advantage, times.
Insert records	115.859	70.718	1.64

Download personal version of SQLMemTable for FREE!.

Accuracer is fastest!

Accuracer Database System is the fastest Delphi client/server database!

Custom Development

Custom Development for you - Delphi and C++ Builder!
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.

Last Releases

08/16/10
MsgCommunicator v.4.40

08/16/10
CryptoPressStream v.2.10

08/13/10
Single File System v.2.80

08/13/10
EasyTable v.6.50

07/20/10
Accuracer VCL v.5.40 is the fastest Delphi C/S database

06/09/10
SQLMemTable v.4.40

05/13/10
Accuracer ODBC Driver v.4.00

02/17/06
EasyTable ODBC Driver v.1.20

12/14/05
Active Query Builder v.1

10/12/04
Accuracer & EasyTable
are the fastest!
Competitive Prices and
Features Comparison

01/28/04
Accuracer CLX v.1.40 for Kylix

Competitive Upgrade

If you own a competing product, you may take a discount up to 50%.
Please, contact our

Voting

What is the maximum size of the database you use?

< 10 Mb

10 Mb - 100 Mb

100 Mb - 1 Gb

> 1 Gb


	Accuracer is fastest!

	Accuracer Database System is the fastest Delphi client/server database!


	Custom Development

	Custom Development for you - Delphi and C++ Builder! Experts in Database, Networking, Data Compression and Encryption. 10+ years experience.


	Last Releases

	08/16/10 MsgCommunicator v.4.40 08/16/10 CryptoPressStream v.2.10 08/13/10 Single File System v.2.80 08/13/10 EasyTable v.6.50 07/20/10 Accuracer VCL v.5.40 is the fastest Delphi C/S database 06/09/10 SQLMemTable v.4.40 05/13/10 Accuracer ODBC Driver v.4.00 02/17/06 EasyTable ODBC Driver v.1.20 12/14/05 Active Query Builder v.1 10/12/04 Accuracer & EasyTable are the fastest! Competitive Prices and Features Comparison 01/28/04 Accuracer CLX v.1.40 for Kylix


	Competitive Upgrade

	If you own a competing product, you may take a discount up to 50%. Please, contact our