Quickest way to find record.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You might want to consider using SQL Mobile and executing a SELECT statement
with the WHERE clause.
 
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
 
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.
 
Thanks Simon. Do you know of a good detailed link that explains setting up
RDA?

Thanks again
 
Thanks Simon. I've got it working in a test environment. I did a record
search against 20,000 records and it was almost instant. Thanks for
everyone's help.
 
Back
Top