General information
Category:
Object Oriented Programming
Title:
Efficient record search in cursoradapters
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
Next
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