zonequestz Posted October 24, 2006 Share Posted October 24, 2006 I run a site that aggregates usage statistics for my subscribers blogs. As my site has grown, close to 30,000 active subscribers, i've been having more and more issues with the amount of data that needs to be recorded. Here's how my site works:The owner of a blog inserts a small javascript scriptlet. In that script, it'll open up a reference to my website, which will then give my site control over generating all the necessarty statistics (ip address, time of hit, referrer, browser, etc, etc).When this worker page is opened up, it'll tally up all the statistics needed and will then open up a mysql connection to my db to store the information. The problem I've been running into is my site is opening up way too many mysql connections at the same time. Setting the mysql_connections to some ridiculous amount just won't cut it. Is there a way that I can keep one page running at all times, that'll keep a db connection open. From there, everytime this worker page is referenced from my subscribers blog, it'll just use the connection that's already open as opposed to opening up it's own connection? Any advice would be beneficial.Thanks, Quote Link to comment https://forums.phpfreaks.com/topic/24981-development-advice/ Share on other sites More sharing options...
steviewdr Posted October 25, 2006 Share Posted October 25, 2006 look at mysql_pconnectP.S. wrong place to post this query.-steve Quote Link to comment https://forums.phpfreaks.com/topic/24981-development-advice/#findComment-114070 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.