Saturday, March 17, 2012

Re: [android-developers] Re: application failing on similar devices

On Sat, Mar 17, 2012 at 11:14 AM, momo <dunn74@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+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

No comments:

Post a Comment