Think I have found one ... will upload a test app (if it works) later this afternoon and post here when it is available.
-- Richard On Jul 11, 9:21 am, Mark Carter <mjc1...@googlemail.com> wrote: > Is there any way to (programmatically) check what version of SQLite is > installed? > > On Jun 24, 1:09 pm, Mark Carter <mjc1...@googlemail.com> wrote: > > > 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 <tom.huba...@gmail.com> > > > > 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 > > > <mjc1...@googlemail.com>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 <tom.huba...@gmail.com> > > > >> Maybe full SQL would give more clue... > > > >>> Tom > > > >>> On 24 čvn, 10:13, Mark Carter <mjc1...@googlemail.com> 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 android-developers@googlegroups.com > > >>> To unsubscribe from this group, send email to > > >>> android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > >>> cr...@googlegroups.com> > > >>> 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 android-developers@googlegroups.com > > >> To unsubscribe from this group, send email to > > >> android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > >> cr...@googlegroups.com> > > >> For more options, visit this group at > > >>http://groups.google.com/group/android-developers?hl=en > > > > -- > > > > --------------------------------------------------------------------------- > > > -------------------- > > > Tom Hubalek (tom.huba...@gmail.com), > > >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 android-developers@googlegroups.com > > > To unsubscribe from this group, send email to > > > android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > > cr...@googlegroups.com> > > > 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 android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en