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

HarleyM

Member
Licensed User
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.
 

BjornF

Active Member
Licensed User
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

Member
Licensed User
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 ...
 
Top