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.
The performance advantage of version 4 is shown on the Diagram 1.
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.
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.