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 -~----------~----~----~----~------~----~------~--~---
