Re: #2 -- you don't want to do beginTransaction() in your UI thread anyway, really, as it can block if file IO is heavy. (I do, and I'm going to change it). You should make the entire transaction into an AsyncTask, which will keep it out of the UI thread entirely.
I can't offhand think of a scenario where the lack of multiple connections (and thus serialization of transactions) would be a serious problem on a handheld device. But perhaps I'm just not stretching my brain enough. Still, for most handheld applications, this isn't going to be a serious limitation. On Dec 15, 1:45 am, Swaroop <[email protected]> wrote: > Experts correct me If I am wrong. But putting out the facts, the > things I didn't like SQLite and hope they'd be bettered in the > future. > > 1) There's no JDBC support for SQLite - I know we can use the Runtime > JDBC Libraries, but it's not recommended > -http://stackoverflow.com/questions/1728476/does-android-support-jdbc > 2) No "Connection" support i.e no parallel transactions. You would > have to use 1 SQLDatabase object for 1 database file and at once only > have only one transaction i.e beginTransaction() and endTransaction() > happening at the same time. So be careful, you don't want your UI > Thread waiting to beginTransaction() while one of your background > threads is holding it for a long time. > > On Dec 15, 2:08 pm, Miguel Morales <[email protected]> wrote: > > > > > > > > > There's also CouchDB for Android:http://www.couchone.com/android > > > On Wed, Dec 15, 2010 at 12:06 AM, Jawwad Farooq <[email protected]> > > wrote: > > > > While surfing I found a very very useful resource: > > > >http://tordtech.blogspot.com/search/label/Benchmarking > > > > Please have a look ...... > > > > On Dec 15, 10:40 am, Jawwad Farooq <[email protected]> wrote: > > >> Thanks for the link.... But I only need the benchmarks for available > > >> Android databases.. > > > >> Any other link?? > > > >> On Dec 14, 10:00 pm, Bret Foreman <[email protected]> wrote: > > > >> > Here's a list of the standard DB performance > > >> > metrics:http://www.tpc.org/tpcc/ > > > >> > Which ones are you interested in? > > > > -- > > > 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 > > > -- > > ~ Jeremiah:9:23-24 > > Android 2D > > MMORPG:http://developingthedream.blogspot.com/,http://www.youtube.com/user/r... -- 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
