Hi,

Have been doing a majot conversion and found some weird speed issues with
DBISAM V3.30.

As an example I ran an SQL script that creates a table with one field in it.
Then I ran insert statements for 900 records.  It took over 10 minutes to
process.  This seems extraordinary slow and I noticed it in various
instances and on different PCs (locally and on server).  Is this normal?

Thanks

Alex

Alex,

<< As an example I ran an SQL script that creates a table with one field in
it.  Then I ran insert statements for 900 records.  It took over 10 minutes
to process.  This seems extraordinary slow and I noticed it in various
instances and on different PCs (locally and on server).  Is this normal? >>

If the INSERT statement has to open/close all involved tables for every
execution then, sure, it can take a long time.  Conver the INSERT statement
to a parameterized INSERT statement and you will see much faster execution:

with MyQuery do
   begin
   SQL.Text:='INSERT INTO MyTable VALUES (:Value1, :Value2)';
   Prepare;
   ParamByName('Value1').AsInteger:=100;
   ParamByName('Value2').AsString:='Test 1';
   ExecSQL;
   ParamByName('Value1').AsInteger:=200;
   ParamByName('Value2').AsString:='Test 2';
   ExecSQL;
   etc.
   end;

--
Tim Young
Elevate Software
www.elevatesoft.com