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] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
