I see yes I had tried the cursor in the past and it does work faster, but I could not get the Filter to work. Do I need to write my own search portion if I use the cursor method?
Thank you for your help. You personally have been a lifesaver to me, in the android field. David On Mar 11, 12:11 pm, NFSpeedypur <[email protected]> wrote: > I believe I understand more of what you are saying about adding the > index. Do you mean to the actual column in the database? Does > filtering the text requery the database each time? > > David > > On Mar 11, 12:08 pm, NFSpeedypur <[email protected]> wrote: > > > No I did not add any index to the to be filtered columns, I am using a > > basic array so I did not know there could be a index? > > > setListAdapter(new ArrayAdapter<String>(this, > > android.R.layout.simple_list_item_1, Titles)); > > > Maybe it will be worth grabbing the subscription on Commonwares > > instead of the book. If I download the pdfs, am I able to print pages > > for personal use or is it only for computer viewing? > > > David > > > On Mar 11, 11:37 am, Mark Murphy <[email protected]> wrote: > > > > NFSpeedypur wrote: > > > > On the emulator it > > > > takes over 5 seconds for the list to be populated. > > > > That feels wrong, but I haven't tried a 9,000-row table. > > > > > And when doing a a > > > > filter (getListView().setTextFilterEnabled(true);) it takes almost 10 > > > > seconds to filter the list. Is it unreasonable to think that about > > > > 9000 entries should be sorted faster? > > > > Did you add an index on the to-be-filtered columns? > > > > > Does your book talk about handling this type of stuff? > > > > There's some coverage of this in the _Advanced Android_ book (not yet in > > > print, beta available to subscribers), with more to come as that book > > > gets expanded over the course of the next 12-18 months. > > > > > I see that > > > > version 2.0 is not in print so I plan to pick it up. > > > > Version 2.0 is available in print. If you're looking at the Amazon page, > > > they *still* have not updated the cover (grrrrrrrrr) -- I'll be trying > > > to do that again later this week. > > > > -- > > > Mark Murphy (a Commons Guy)http://commonsware.com > > > _The Busy Coder's Guide to Android Development_ Version 2.0 Available! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" 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-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
