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

Discussion in 'Questions (Windows Mobile)' started by HarleyM, Jan 9, 2008.

  1. HarleyM

    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.
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    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.
     
  3. BjornF

    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
     
  4. operprincipal

    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 ...
     
Loading...