Question

What is the fastest way to find data in SQLCE in Windows Mobile (using C#)? I have a database with one million records. Is the fastest way an SQL query, a DataReader, or what?

Answer 1

By far the fastest way is to not use the query processor at all. Index the table to the field you want to search on and then use a SqlCeCommand with TableDirect and open a reader. Just adding the query procesor makes it an order of magnitude slower.