time, causing contention inside SQLite?
From what you've described, it seems possible - since AsyncTask uses a
pool of more than one thread, and you also mentioned running this
query on the UI thread as well.
I would try to use AsyncQueryHandler, which processes requests one at
a time, or some other mechanism to ensure that these queries are
serialized -- if only for the sake of debugging.
As far as finding an index, two things come to mind.
One is a cache of prior query results (perhaps using a SparseArray or
something like it) and then looking up indices in this cache.
The other is writing a count(*) type query just to get the index.
Perhaps you've already considered both, given your vast experience, if
so, my apologies for suggesting something so obvious.
-- K
21 марта 2012 г. 16:54 пользователь Zsolt Vasvari <zvasvari@gmail.com> написал:
> But that should effect both the UI thread query and the worker thread query.
> But only one runs slow.
--
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