Re: Datasets with large amounts of data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: glenn (ghancock_at_softeksoftware.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 10:32:20 -0500

I'm a little confused so sorry for the questions...
1) Is this a webservice type app where data is being queried and then
transferred to the PDA to view or is the database actually residing on the
PDA?

2) Are you using datasets to store the data in order to display in your form
elements?

3) I'm a little confused about the comments of storing the data in
sqlserver db and then asking if things would speed up if they were in
sqlserver db. Either way, the datasets are going to be the middle ground
for storing the data for your components.

What types of searching/sorting are you doing that is slow? I think maybe a
little more info on what your app is doing might help provide a better
answer for you...

Sorry if I missed something that caused me to be more confused than
necessary...

glenn
"mikeb" <mike@nohostanywhere.com> wrote in message
news:uE$agmDFFHA.560@TK2MSFTNGP15.phx.gbl...
> I came onboard to help finish a ppc application (vb.net cf) for a company.
> The original developer is loading datasets from a sql server database for
> data handling. This worked pretty well (but very messy coding in my
> opinion) up until we started dumping some real life data to the scanner
> (3000-4000 records).
>
> With the large amount of data being loaded into the datasets lookups take
an
> exceptional amount of time to complete.
>
> My first question is - if we were to convert the datahandling method to
> sqlce, would this resolve the speed issue? Assuming we can index the data
> properly.
>
> Second is, is there any way to speed up a dataset search? They're using a
> simple looking .select method to do the lookups:
> ie. drow = dsVEKP.Tables(0).Select("UCC = 1234455566777")
>
> Can you index a dataset?
>
> Thanks!!
>
> Mike
>
>

Quantcast