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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: CEDevice_Brian (CEDeviceBrian_at_discussions.microsoft.com)
Date: 07/01/04


Date: Thu, 1 Jul 2004 11:24:01 -0700

Nope.
I did discover by running the csvDA.fill on the PC that there were extra commas in a couple records. On the device, csvDA.fill just kept going until I tried to kill the app. Then it threw the error. I have the data cleaned up now, but it is still painfully slow.
Thanks everybody for the help, but at this point, I am thinking that this section may inspire the users to go with the wireless network so they don't have to work in batches.

"Ginny Caughey [MVP]" wrote:

> Perhaps that's just how long it's going to take with the data you have. Do
> you have a lot of fields that require converting from string to something
> else?
>
> --
> Ginny Caughey
> ..Net Compact Framework MVP
>
>
>
> "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?????
>
>
>