RE: Datasets with large amounts of data

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

From: Ilya Tumanov [MS] (ilyatum_at_online.microsoft.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 23:04:21 GMT

Sure, you can use normal SQL CE queries like "Select * from WhateverTable
where UCC=1234455566777".

As to speeding up the search, are you m measuring the first search? How
about consequential ones?
Also try updating to SP3. This particular operation was optimized in SP2
and above

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
> From: "mikeb" <mike@nohostanywhere.com>
> Subject: Datasets with large amounts of data
> Date: Wed, 16 Feb 2005 07:10:10 -0800
> Lines: 24
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> X-RFC2646: Format=Flowed; Original
> Message-ID: <uE$agmDFFHA.560@TK2MSFTNGP15.phx.gbl>
> Newsgroups: microsoft.public.dotnet.framework.compactframework
> NNTP-Posting-Host: 12.144.250.205
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.compactframework:22643
> X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
>
> 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
>
>
>