title: Optimum number of insert queries in a Batch Execute
body: <p>I am running some insert queries using JDBC's executeBatch method. 
  Let me first explain a little bit about the application. 
  There's a web app which will send some insert statements to a cache in async way when user navigates through some webpages. When the size of the cached queries grows to certain number, say 'n', the queries will be executed as a batch using the executeBatch method of JDBC.</p>
  
  <p>I am not really from a DB background and not sure how to come up with the value of 'n'. What all factors will determine it and how do I figure out some approximate value mathematically before doing load test. </p>
  
  <p>As far as usage is concerned, I am expecting around 72000 insert queries in an hour and the priority is the smooth running of the web app and not insertion of the data. </p>
  
  <p>Please suggest.</p>
  
  <p>Edit - update number of queries to 72000 per hour from 2000, my apologies, had wrong data before :(</p>