Mysql effective utilization
I have a website running. At the backend i am using mysql.
for preparing a single page i need to connect to database more than 50 times.
i am using mysql tables to store the data and simply querying those using SELECT statement by making a connection in php. Since the number of connections made for a single page to mysql is large(50 or more) it takes few seconds of delay to actually prepare the page for the user.
i need as how to get almost all the data in one or fewer connections to the database.
   
   i am already using INNER JOINS to join the tables so as bring the data from different tables in one connection wherever possible.
Mysql effective utilization
===

I have a website running. At the backend i am using mysql.
for preparing a single page i need to connect to database more than 50 times.
i am using mysql tables to store the data and simply querying those using SELECT statement by making a connection in php. Since the number of connections made for a single page to mysql is large(50 or more) it takes few seconds of delay to actually prepare the page for the user.
i need as how to get almost all the data in one or fewer connections to the database.
   
   i am already using INNER JOINS to join the tables so as bring the data from different tables in one connection wherever possible.