I have read all posts about SQLIte and haven't found a real solution yet. -I have a database with 1000 rows, and the main search columns indexed.
-These are displayed in a ListView. Since I am using the FastScroller functionality I need to load them all (1000 rows) in a cursor so there are no delays when scrolling with the FastScroller thumb. -On the layout I have a textbox on top of the listview to allow the user to filter which rows to see (if he wishes to do any filtering). -On every key stroke on the filter textbox I execute a query with the textbox value as constrain. I use the setTextFilterEnabled and run query in the background functionality. - As a note the data is stored in the database in lower case and ordered, so searching is much faster. -The search is done through a GLOB '<constrain>*' command ...and still it takes around 3-5 seconds to execute every query. Is there any other option to filter a listview that isn't to perform queries all the time? I tried on the 'getView' method not to show any informaiton that doesn't fall into the constrain but doesn't work correctly as the cursor still contains all the rows and the scrollbars and fastscroller still can go through all of them showing then empty rows in the listview. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
