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