Re: [ANN] SQLMemTable v.3.05 - fast and easy-to-use in-memory database with SQL support

Hi,

By looking at the benchmark test of the SQLMemTable compare with KBMMemTable, I then give myself a try on the SQLMemTable. However, the result disappoint me and it doesn't perform that well. Here is my result:

I have a firebird 1.5 table with the following structure:


CREATE TABLE "HR_DEPARTMENT"
(
"CODE" VARCHAR(20) NOT NULL,
"DESCRIPTION" VARCHAR(160),
"ISDEFAULT" CHAR(1),
"ISACTIVE" CHAR(1),
"ATTACHMENTS" BLOB SUB_TYPE 0 SEGMENT SIZE 512,
PRIMARY KEY ("CODE")
);

The table fills with 550,000 rows. I use Delphi 2006 and DBExpress driver (unidirectional dataset) to load the table into both SQLMemTable and KBMMemTable:

SQLMemTable1.Close;
SQLMemTable1.ImportTable(SQLDataSet1);
SQLMemTable1.Open;

It takes 58 seconds to complete the 500k rows loading. However, the same loading operation with KBMMemTable only takes 13 seconds.

Is that any properties I need to change in order to make it perform fast as what you stated in the benchmark test?

Thank you very much.

--
Best regards,
Chau Chee Yang

E Stream Software Sdn Bhd
URL: www.sql.com.my
SQL Financial Accounting
.