title: websql insert slow
body: <p>I have about 300 records I need to insert into a websql.  I started out by writing 300 separate tx.executeSql insert statements without parameters.  </p>
  
  <pre><code>tx.executeSql("INSERT INTO `beerlist` VALUES ('1', '21st Amendment', 'Back in Black IPA', '83', 'IPA', 'A');");
  </code></pre>
  
  <p>On Chrome, this takes 2ms.  Running thru phonegap on Android, this takes about 43,438 ms.  So I switched to iterating over some JSON &amp; using prepare statement. Like so:</p>
  
  <pre><code>var beerList = {"beers":[{"beerid":"1","brewery":"21st Amendment","beername":"Back in Black IPA","bascore":"83","beertype":"IPA","beertable":"A"}}
  
  $.each(beerList.beers, function(i, object) {
                      var insert = 'INSERT INTO beerlist VALUES (?, ?, ?, ?, ?, ?)';
                      tx.executeSql(insert, [object.beerid, object.brewery, object.beername, object.bascore, object.beertype, object.beertable], Beer.successInsert, Beer.failureInsert);
                  });
  </code></pre>
  
  <p>I read where prepare should be faster, but I'm seeing the same performance on Chrome &amp; actually a slightly worse performance thru Phonegap on Android at 53,559 ms.  I can't believe it's going to take ~50 seconds to insert 300 records.  Any thoughts?</p>