Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Minimize execution time |
Mon, Aug 13 2007 1:33 AM | Permanent Link |
dhanashreep@tpt.com | 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. |
Mon, Aug 13 2007 7:12 AM | Permanent Link |
Dhanashree | 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. |
Mon, Aug 13 2007 4:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |