>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
Instead of AfterCursorFill can you add indexes before this method is run? In the Init of CA, for example?
If it's not broken, fix it until it is.
My Blog