>Hi,
>
>I am working on converting an existing application from native database to SQL Server database using CursorAdapters. Since records returned from a cursoradapter are not indexed, I added a couple of INDEX ON statement in AfterCursorfill() so that I can do a SEEK in the cursor. However, I soon realized that this is causing a bad performance issue when the table associated with the cursoradapter is large.
>
>Does anyone have a better idea on how to do a record search in a cursoradapter that matches the speed of an index seek?
>
>Thanks in advance for your help!
>
>Wen

As most others told you, do not bring down the entire table and then seek. Ask the user what they seek and then use that to grab records.