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
