Could you post your code here. compileStatement is usually for batch reusable SQL statement, It's kind of best practice to use this in this case. no reason that it's slower than normal SQL.
On Apr 14, 1:17 am, Alok Kulkarni <[email protected]> wrote: > @Walter, i tried that out. Instead of sb.toString() , it the insert > statement string over there with Compile statement format.. > Its taking *27* *seconds *!! > The database schema is as follows > Table *Artist* > id Integer Primary Key > name nvarchar(200) > > Table *Album* > name nvarchar(200) > label nvarchar(200) > multiple_artists integer > artist_id integer > id integer Primary Key > > Table *Songs* > artist_id integer > album_id integer > id integer Primary Key > name nvarchar(200) > > > > On Mon, Apr 12, 2010 at 9:26 PM, Dave Johnston <[email protected]> wrote: > > On Apr 12, 7:50 am, 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. > > > Can you post the schema of the database you're inserting into? > > > -d > > > -- > > 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%2Bunsubs > > [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
