We are migrating from DBISAM to ElevateDB ....fetching data then creating local tables and filling data into the
tables is taking lesser time in DBISAM..... now its taking five to eight minutes more with ElevateDB. It includes  
creating local tables with Create Table query followed by Create Index Query. Although time for fetching the
data is same. How will i optimize this time ? While populating Data it is taking lesser time for DBISAM tables,
does appending and posting for elevate DB table takes time ? Table Object while filling the Data is of type
TDataSet.

Can i use something like Stored Procedure to club the queries ? will it improve performance ?

dhanashreep@tpt.com wrote:

We are migrating from DBISAM to ElevateDB ....fetching data then creating local tables and filling data into the
tables is taking lesser time in DBISAM..... now its taking five to eight minutes more with ElevateDB. It includes  
creating local tables with Create Table query followed by Create Index Query. Although time for fetching the
data is same. How will i optimize this time ? While populating Data it is taking lesser time for DBISAM tables,
does appending and posting for elevate DB table takes time ? Table Object while filling the Data is of type
TDataSet.

Dhanashree,

<< We are migrating from DBISAM to ElevateDB ....fetching data then creating
local tables and filling data into the
tables is taking lesser time in DBISAM..... now its taking five to eight
minutes more with ElevateDB. It includes  creating local tables with Create
Table query followed by Create Index Query. >>

Are you sure that you're creating the tables locally and not on the server ?
If you could send me the code that you're using, I can verify that what
you're doing is correct.

<< Although time for fetching the data is same. How will i optimize this
time ? While populating Data it is taking lesser time for DBISAM tables,
does appending and posting for elevate DB table takes time ? Table Object
while filling the Data is of type TDataSet. >>

EDB should be significantly faster than DBISAM when it comes to appending
and posting, so if it is taking longer than something like what I mention
above is probably the reason for the longer times.

--
Tim Young
Elevate Software
www.elevatesoft.com