Thanks. The single transaction method worked.
On Wed, Aug 4, 2010 at 5:40 PM, Jesse MacFadyen <[email protected]>wrote: > Oops, should have read on... > > Sent from my iPhone > > On 2010-08-04, at 2:38 AM, Jesse MacFadyen <[email protected]> > wrote: > > The reason you are seeing all 95's is a scope issue, you need a closure to > perform an asynchronous op like this. > > > > On 2010-08-02, at 7:27 PM, sajid saiyed < <[email protected]> > [email protected]> wrote: > > Hi, > I am making an iPad app which uses localstorage Sqlite database. > > I am having some problems with the performance of the database queries. > > Here is my code: > > addG: function(fname, fid){ > alert('4'+fid); > for(var i=0; i<95; i++){ > alert('5'); > this.dbConn.transaction(function (transaction) { > transaction.executeSql('INSERT INTO `GTable` (`id`,`gname`) VALUES (?, > ?);', [fid, i], classObj.nullDataHandler,classObj.errorHandler); > }); > } > } > > What actually happens that the insert query works so slow that after a > first few records, all entries insert a value of 95 in the 'gname' column. > > Is there an optimised way of inserting multiple entries in sqlite database? > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "iPhoneWebDev" group. > To post to this group, send email to <[email protected]> > [email protected]. > To unsubscribe from this group, send email to > <[email protected]> > [email protected]. > For more options, visit this group at > <http://groups.google.com/group/iphonewebdev?hl=en> > http://groups.google.com/group/iphonewebdev?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "iPhoneWebDev" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<iphonewebdev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/iphonewebdev?hl=en. > -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" 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/iphonewebdev?hl=en.
