Hi,
On a site I work on, there is a page called references. page contain many references (apox 70 ) for each reference I make 2 queries to get more data about the reference.

this means 1 + 70*2 = 141 queries each time the page is called !!!

is it ok to make that much connections for a page? Or should I look for another solution.

note: page renders fast enough on localhost.

Without knowing very much about your situation, I would say that if your solution is an elegant one, page rendering is fast, and most importantly, it works, there shouldn't be any reason to change unless it is slowing down the development process.

It depends on the queries themselves. A simple query searching a small amount of data can be run as much as you want with no problems. Same query with 2 million rows might take 40 seconds to run. A complex query on a large amount of data, if optimized, may run quickly, but change which fields are indexed and that same query may take an enormous time to run.

Check out http://www.webmaster-talk.com/the-da...execution.html where I just did an analysis based on tips from some people here on 5 possible ways of performing one query. You'll notice that my best attempt was 20 times faster than the nearest other choice.