title: Java MySQL Table
body: <p>I have two java processes namely Ticket Creation and Billing Daemon. Both of these processes use same MySQL Innodb Table "Billing". Ticket Creation mainly creates billing ticket and it includes inserts/update ticket of users.  Billing Daemon retrieves the ticket and then sends billing to users finally updating result (success/failure) to "Billing" Table. Each Day billing tickets are created for thousands of users and if billing is created today, it's called "New Ticket" and others created previously are called "Old Tickets".  The problem which I am facing is, both the Processes use same Table and Insert/Update Record is getting very slow.  Solution which I tried </p>
  
  <pre><code>1. Stopped billing while ticket creation: I got late to bill users and billing 
  success rate got slow. 
  </code></pre>
  
  <p>When both the processes are used, ticket creation got very slow  and billing were mostly sent for "Old Tickets" rather "New Tickets" where failure rate becomes high. </p>
  
  <p>Please suggest, how can I come to solve this issue? Will creating Child and Master Table of "Billing" will solve? OR do I have to create another table? OR is there any appropriate solution? </p>
  
  <pre><code>Database is in Amazon RDS using MySQL Innodb. Please adivse urgently as 
  my billing rate is getting really slow. 
  </code></pre>
  
  <p>Thanks in advance.. </p>