Re: Quickest way to find record.

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

Try looking here: http://msdn.microsoft.com/mobility/sqlmobile/default.aspx

Cheers
Simon.

"blue_nirvana" <bluenirvana@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35763916-455D-4BD3-A1E5-FC3C829083E2@xxxxxxxxxxxxxxxx
> Thanks Simon. Do you know of a good detailed link that explains setting
> up
> RDA?
>
> Thanks again
>
> "Simon Hart" wrote:
>
>> SQL CE 3 (latest version) is alot faster over SQL CE 2 (CF1 old version)
>> and
>> I bet my bottom dollar its faster than what you are doing now. I have not
>> tested a 50,000 record table in my app as I will not be using anywhere
>> near
>> that, but a table containing 8,000 records, returning a DataSet using a
>> simple SELECT statement is almost instant.
>>
>> I find it is always the UI that takes the time when streamlining my
>> applicatiions. I have found reading from XML files is painfully slow in
>> CF 2
>> and CF1.
>>
>> Cheers
>> Simon.
>>
>> "blue_nirvana" <bluenirvana@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EA2BF0A3-58B8-47CF-AD47-574074B78CD8@xxxxxxxxxxxxxxxx
>> > OK. Is RDA the best way to get the data from SQL Server to my local
>> > SQL
>> > Server CE database? Also, even if I use a local database, such as SQL
>> > CE,
>> > what type of response time should I expect when trying to find one
>> > record
>> > in
>> > a table with say 50,000?
>> >
>> > Thanks
>> >
>> > "Alex Yakhnin [MVP]" wrote:
>> >
>> >> You might want to consider using SQL Mobile and executing a SELECT
>> >> statement
>> >> with the WHERE clause.
>> >>
>> >> --
>> >> Alex Yakhnin, .NET CF MVP
>> >> www.intelliprog.com | www.opennetcf.org
>> >>
>> >>
>> >> "blue_nirvana" wrote:
>> >>
>> >> > Background: I have a smart device app that is used for scanning
>> >> > items
>> >> > and
>> >> > validating them against a datasource. Currently, I'm using a
>> >> > dataset
>> >> > and
>> >> > datatable to store the data, that I'm getting from a SQL Server, and
>> >> > then
>> >> > using a dataview to check if the scanned item is in the datatable
>> >> > using
>> >> > the
>> >> > filter criteria. This worked fine for a small set of data, but
>> >> > slowed
>> >> > down
>> >> > significantly once I started testing with more data. There could be
>> >> > anywhere
>> >> > from 5 to over 50,000 records to validate against. The user just
>> >> > wants
>> >> > to
>> >> > scan as fast as possible unless they come across an invalid item. I
>> >> > don't
>> >> > want the user having to wait for the app to validate the item.
>> >> >
>> >> > I'm relatively new to SDA and so I was hoping someone could help me
>> >> > to
>> >> > figure what would be the best and quickest method to accomplish the
>> >> > above.
>> >> >
>> >> > Thanks
>>
>>
>>


.

Relevant Pages

  • Re: Quickest way to find record.
    ... Thanks Simon. ... Is RDA the best way to get the data from SQL Server to my local SQL ... Also, even if I use a local database, such as SQL CE, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Last Login
    ... If that's the SQL that's opening the recordset, ... "Simon" wrote in message ... >> login but intLastLogin does not get updated, ...
    (microsoft.public.access.queries)
  • Re: performance problem...
    ... The HD-Type is a seagate scsi drive and there is a RAID0 installed... ... there are 2 disks. ... > very helpful in troubleshooting SQL FTS issues? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Fehler bei verbindung zu SQL Sever 2005 Express
    ... Wenn du mit Sql Express 2005 arbeitest mußt du die Protokolle SQL Server Configuration Manager unter Network Vonfiguration erst aktivieren ... "Simon Grimm" schrieb im Newsbeitrag ... Wenn ich das programm auf ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • Re: execute string
    ... However - I always avoid using EXEC when I can, for security reasons ... Author of "SQL Server 2000 Fast Answers..." ... "simon" wrote: ... >> Joseph Sack ...
    (microsoft.public.sqlserver.programming)