do you have some code specifically showing the sequence and the syntax ? AAfaik a transaction SHOULD make it faster accroding to this documentation : http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#transactions
On 12 apr, 12:32, Alok Kulkarni <[email protected]> wrote: > I have started the transaction before the 1st insert , and ended it after > the last insert.... > Thanks, > Alok. > > On Mon, Apr 12, 2010 at 4:01 PM, Alok Kulkarni <[email protected]> wrote: > > Ok, > > @Yahel:- For the insertion of same records on a Palm device(Say Palm Pre) , > > its taking 3 seconds.. > > On an IPhone , its taking 1 or 2 seconds.. > > Here is an example of what i am doing.. > > private Boolean addAlbumDB(int AlbumId, String Name, String Label, > > int MultipleArtists, int ArtistId) { > > long result = -1; > > > try { > > > ContentValues initialValues = new ContentValues(); > > initialValues.put(KEY_ID, AlbumId); > > initialValues.put(KEY_NAME, Name); > > initialValues.put(KEY_LABEL, Label); > > initialValues.put(KEY_ARTIST_ID, ArtistId); > > initialValues.put(KEY_MULTIPLE_ARTISTS, MultipleArtists); > > > result = db.insert(DATABASE_TABLE, null, initialValues); > > > } catch (Exception e) { > > Log.i("Exception in addAlbumDB", "" + e.toString()); > > return false; > > } > > > if (result == -1) > > return false; > > return true; > > } > > > The above function is called for around 2000 times.. > > Similarly there are 2 3 more functions for other tables. > > Thanks, > > Alok. > > > On Mon, Apr 12, 2010 at 2:33 PM, Michael Rueger > > <[email protected]>wrote: > > >> On 4/12/2010 10:59 AM, Yahel wrote: > > >>> Hi Alok, > > >>> Posting some logic, or some sql would help us see if you are missing > >>> something :) > > >> (excessive) use of indices comes to mind :-) > > >> Michael > > >>> Yahel > > >>> On 12 avr, 08:50, Alok Kulkarni<[email protected]> wrote: > > >>>> Hi, > >>>> I am inserting around 7000 to 8000 records in my database having 4 > >>>> tables > >>>> each having 3 to 4 columns.Its taking me around 22 seconds to do the > >>>> insertion which is i think is too long. I am using transaction while > >>>> doing > >>>> this without which its taking around 55 seconds. > >>>> According to SQLite documentation , inserting 10000 records in a > >>>> database > >>>> takes time around 2 to 3 seconds. > >>>> Am i missing something , or is the behaviour correct? > >>>> Thanks, > >>>> Alok > > >> -- > >> 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 > > >> To unsubscribe, reply using "remove me" as the subject. -- 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
