title: Mutliple SQL Query Request - Is Better with Single or Multiple Connection?
body: <p>I created an application, which deals with multiple database table at a same time. At present I created a single connection for the process and trying to execute query like select query for multiple tables parallel.
  Each table may have hundreds of thousands or millions of records. </p>
  
  <p>I have a connection and multiple statements that are executing parallel in threads.
  I want to find out is there any better solution or approach?</p>
  
  <p>I am thinking that if I use connection pool of for example 10 connections and run multiple thread (less than 10) to execute select query. Will this increase my application's performance?</p>
  
  <p>Is my first approach okay?</p>
  
  <p>Is it not a good approach to execute multiple statement same time (parallel) on the database?</p>
  
  <p>In this forum <a href="https://stackoverflow.com/questions/19345485/mysql-single-or-multiple-connections">link</a> mentioned that single connection is better.</p>