Hmmm - this is a bit worrying, isn't it? How to possibly test SQL which can potentially run so differently on different devices?
One starting point would be get a list of SQLite version numbers on each device available... 2010/6/24 Tomáš Hubálek <[email protected]> > SQL Lite is definitely simpler but in Oracle it sometimes happens that the > same SQL has very different performance on different versions because of > different explain plan. > > Tom > > On Thu, Jun 24, 2010 at 12:48 PM, Mark Carter <[email protected]>wrote: > >> True - though the SQL is a little complex and I'd like to simplify it >> before posting. >> >> However, whatever the SQL is, there has to be an explanation for the >> different outcome. >> >> 2010/6/24 Tomáš Hubálek <[email protected]> >> >> Maybe full SQL would give more clue... >>> >>> Tom >>> >>> On 24 čvn, 10:13, Mark Carter <[email protected]> wrote: >>> > Same data, same code, but different results on these two devices. >>> > >>> > On the Nexus One, the (INNER JOIN) query runs (first call to >>> > Cursor.moveToNext()) after a fraction of a second but on the Hero it >>> > just hangs. >>> > >>> > I haven't been able to reduce the scenario to something simple yet, >>> > but it seems to involve using OR within an ON clause. >>> > >>> > Anyone know why there might be a difference on these two devices? >>> >>> -- >>> 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]<android-developers%[email protected]> >>> For more options, visit this group at >>> http://groups.google.com/group/android-developers?hl=en >> >> >> -- >> 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]<android-developers%[email protected]> >> For more options, visit this group at >> http://groups.google.com/group/android-developers?hl=en >> > > > > -- > > ----------------------------------------------------------------------------------------------- > Tom Hubalek ([email protected]), > http://android.hubalek.net, http://blog.hubalek.net/ > http://facebook.com/thubalek, http://www.linkedin.com/in/thubalek > http://twitter.com/thubalek, http://twitter.com/android_dev_tom > > > > -- > 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]<android-developers%[email protected]> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > -- 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
