Exporting Data Speed...

[Ocean West]

in a current solution i am working on that has about 2000 records it takes several minutes to export this data via xml to csv or even tab / or any other format. Takes minutes and the counter steps in increments of 5 records at a time. This file is single user local. And still takes awhile to finish. Trying to figure a way to speedup the export, as this is only the tip of the iceberg soon there will be thousands of records.

Thoughts?

[Richard Rönnbäck]

Assuming it's not a corrupt file the only thing I can think of is if you have a lot of unstored calculation fields. Depending on the complexity of the calculations that certainly adds a lot to the export time

[Ocean West]

Indeed there are about 60 fields in total and about 30 are un-stored calcs.

I created a table of just the fields all set as text or numbers then did an import into this utility table but the import is only marginally shorter.

I also grabbed a list of the unique record numbers in to a variable and did a looping script creating records setting the id field, then let each field look up the data from the original table. - this took terribly long and there was no indication of activity unlike imports/exports that shows progress bars.

However export from this table was almost instantaneous.

[Richard Rönnbäck]

It certainly seems to be the unstored calcs that cause the problems then.

Try to do an export of only the fields that are stored and see if the speed is normal then, and then add in the other fields until you find the culprits.

Would it be possible to replace any of the calculations with Auto Enter data?