Zen Cart Not Closing DB Connections URGENT HELP

[Vger]

Make sure that you did not enable persistent connections when you set up Zen Cart. This is what you should see in both configure.php files:
define('USE_PCONNECT', 'false');

If it says 'true' then that could be the source of your problem.

Vger

[coastalfog]

Hey Vger,
They are both set to FALSE.

Any other ideas?

Cris...

[Vger]

If those settings are both set to 'false' then it's likely a hosting issue. Some hosts who have over-stuffed their servers get onto people running dynamic sites and tell them that they are using up too many resources on the server and need to take action to reduce their usage or else fork out for a dedicated server. 1and1 does this but so do others.

However, even on the best of shared servers, if it is a very busy website (100 customers at a time online, or more) then the problem can simply be that you keep hitting max sql parent and child queries limits, in which case things will either time out or slow down. In this case you would need either a Virtual Dedicated Server or a full Dedicated Server.

Vger