CSV file read still slow in V6.01 but other tasks much improved

[HarleyM]

Hi,

I've had a program on the go for some time that reads & writes data to a CSV file (primarily to allow easy importing into excel) The program has now been updated to v6.01 but I'm not seeing any dramatic speed improvements on the device, particularly with the initial load which includes reading in the CSV file into a table (now around 100 records, 8 fields) using table.loadCSV & then inserting a column within the table. (Adding a column & moving the contents of another column into it, thereby creating a clear column in the middle)

Unfortunately it all takes around 32 seconds, which is only a slight improvement on the 35secs in the previous version. Is there any reason as to why this might be the case or a technique that might improve things.

 

[Erel]

The CSV loading method was improved.
This is not Basic4ppc code but rather .Net code so the improvement is not too significant.
LoadCSV is in fact faster in .Net CF 1.0 than .Net CF 2.0 because of a structure change in the .Net control.

The solution is to use a SQL database instead. It will be much faster.

 

[BjornF]

Dear Harley and Erel,

Isn't this a rather long time anyway? I have a program which loads two csv databases, one with 10 columns (244 records) and one with 2 columns (100 records). That takes less than 10 seconds.
(And the program was compiled with version 5 !).

Just curious.

all the best / Björn

 

[operprincipal]

Hi! Realy new in this forum, i´m a little bit surprised, because
i use to load a 80000 "record" csv database with 12 columns from a 13Mb file in
less then 10 seconds.
It's not normal?

Also curious ...