Re: How do I speed Up dataset.ReadXML????????

From: Ignacio Machin \( .NET/ C# MVP \) ("Ignacio)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 14:32:49 -0400

Hi,

 Try my suggestion, using a text file where the separator is a control char,
20 for example, that avoid having to process the fields looking for
embedded comma inside the values.

 also maybe in your case with so many records if you need to convert to
numeric values it may be faster ( but not elegant ) keep them as string and
convert them in the spot.

 just let me know if you need the code for this.

Cheers, 

-- 
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"CEDevice_Brian" <CEDeviceBrian@discussions.microsoft.com> wrote in message
news:2D0BC144-6389-4DC7-AE2A-3B2DE0C3B7FC@microsoft.com...
> I'm now creating a CSV with 11,000 records, 20 fields per.
>
> Code used is
>            csvDA = New OpenNETCF.Data.CSV.CSVDataAdapter(csvFile, True)
>             'fill dataset from csv
>             csvDA.Fill(XREFDataset, tName)
>
>
> It's been going for over 15 minutes now.
>
> What am I doing wrong?????

Relevant Pages

  • Re: compilation problem with module function interface definition
    ... >> decimal floats start appearing, it would be wise for users to avoid ... > for numeric literals was a decimal KIND (as previously suggested ... I guess I sort of passed over that suggestion because I don't ...
    (comp.lang.fortran)
  • Re: Bruising at injection sites?
    ... Grandpa Chuck wrote: ... Anyone have a suggestion on how to avoid the bruising? ...
    (alt.support.diabetes)
  • Re: (OT) Singing my same old sad song.
    ... they avoid the full text of what has been written, and claim the NEED to drive to work, ignoring such things as car pooling, making fewer trips to the store, shopping closer to home, and otherwise cutting back on miles driven. ... Nobody has suggested that anyone STOP driving, yet most of the responses have been dished out as though that WERE the suggestion. ...
    (rec.outdoors.rv-travel)
  • [PATCH] kmemleak: Rename kmemleak_panic to kmemleak_stop
    ... This is to avoid the confusion created by the "panic" word. ... (following Pekka's suggestion) ... struct early_log *log; ...
    (Linux-Kernel)