On Sat, Mar 17, 2012 at 11:14 AM, momo <dun...@gmail.com> wrote: > More generally, do you see anything especially problematic with this: > > 1. a single sqlite query joining 2 tables via a 3rd bridge table, selecting > 2 colums with an order by and collate unicode, that'll return 3000-4000 > rows. invoked with db.rawQuery.
That is likely to be slow. Be sure you are doing this part on a background thread (e.g., Loader, AsyncTask) -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android Training in DC: http://marakana.com/training/android/ -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
