Quickest way to find record.

[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

 

[Guest]

You might want to consider using SQL Mobile and executing a SELECT statement
with the WHERE clause.

 

[John T]

You might want to consider using SQL Mobile and executing a SELECT
statement with the WHERE clause.

At least use a database system that allows querying of *some* kind.

--
John T
http://tknowlogy.com/TknoFlyer
http://www.pocketgear.com/products_search.asp?developerid=4415
Reduce spam. Use Sender Policy Framework: http://spf.pobox.com
____________________

 

[Guest]

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

 

[Simon Hart]

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.

 

[Guest]

Thanks Simon. Do you know of a good detailed link that explains setting up
RDA?

Thanks again

 

[Simon Hart]

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

Cheers
Simon.

 

[Guest]

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.