General information
Category:
Object Oriented Programming
>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
Do the search into the SQL Server with indexed table
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only