When you see huge differences like this on joins it often means one of the inner columns is not in an index _and_ there exists at least one pair of tables being joined that won't fit in cache. So I'd bet the difference between the two devices is SQLlite caching, which could be either RAM available to SQL or in th flash controller.
On Mar 20, 8:02 pm, momo <[email protected]> wrote: > that was it - i had forgotten to pk one id column in one of the join tables > - adding that and it's night-and-day - under 1 second, compared with ~30 > before. thanks all for reinforcing that concept. very glad i didn't try > to convert the whole thing to a Java model. -- You received this message because you are subscribed to the Google Groups "Android Developers" 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-developers?hl=en
