1

I'm using phonegap to access a database on the device to perform some inserts, however I'm getting less than ideal performance.

Questions:

  1. I see that there are some SQLite plugins for phonegap out there, do these have better performance comparing with the default Storage API?

  2. what are the best/most used SQLite plugins for all three major platforms? (android, ios, wp)

  3. how do I improve phonegap SQLite performance?

the two most important performance improvement that I can do if I were to interact with SQLite directly according to this thread seems to be to

  • perform the inserts in a transaction
  • prepare the insert statement

all my insert happened in one transaction, but how would I make the second item happen? is it possible with the Storage API?

Thanks.

Community
  • 1
  • 1
George
  • 1,552
  • 1
  • 17
  • 26

1 Answers1

0

Although this posting isn't directly aimed at Cordova based applications, there might be some useful information in this posting. I do both native and Cordova based mobile programming and I find that SQLite is generally the same animal regardless of OS, Hardware or development platform. Hope this helps
 
  Improve INSERT-per-second performance of SQLite?

Community
  • 1
  • 1
Robert Sherman
  • 391
  • 4
  • 6
  • Sorry I was speaking specifically about performance tweaks. I use the com.phonegap.plugins.sqlite solution, and haven't found any reason to use anything else yet... – Robert Sherman Oct 10 '14 at 14:59