I have been working with a Mysql DB and PHP 4 which crashes and does not reconnect for about 3 minutes, when I run a queries in several places on our site, http://www.pre-dating.com/. It is specifically when we run an intensive queries with nested queries and/or queries which use the select unique. Is this a common thing? The ISP we use says it is the way we designed our database and wrote the code, which I am optimizing. I think it is a memory issue with the server the site is on. The guy in charge of the ISP says they have enough memory on that server, but the symptoms are pretty clear. After a big query, towards the end of the query the Mysql connection dies. the Mysql database does come back in a few minutes. What do you guys think?
dgudema
