Hi there.
I'm using Links SQL in dynamic mode, cgi interface. I recently wrote a very simple sitewide traffic tracking script in PHP that I'm calling on each page through an image tag (not sure if that's the best way to do that, but it appears to be working). The PHP script is essentially just recording into a mysql database some basic information about the pageview.
At any rate, I'm trying to be efficient in my use of mysql connections. The PHP tracking script uses mysql_pconnect(), which, as I understand it, will only make a new connection if there isn't one currently open for the same host and user. My question is: does Links SQL use a persistent connection? I'm hoping it does, so I can make sure I'm not opening a new connection every time someone views a Links page, and then another when the PHP tracking script records its information. Two connections per page view seems a bit excessive.
Thanks in advance for any information or advice.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
I'm using Links SQL in dynamic mode, cgi interface. I recently wrote a very simple sitewide traffic tracking script in PHP that I'm calling on each page through an image tag (not sure if that's the best way to do that, but it appears to be working). The PHP script is essentially just recording into a mysql database some basic information about the pageview.
At any rate, I'm trying to be efficient in my use of mysql connections. The PHP tracking script uses mysql_pconnect(), which, as I understand it, will only make a new connection if there isn't one currently open for the same host and user. My question is: does Links SQL use a persistent connection? I'm hoping it does, so I can make sure I'm not opening a new connection every time someone views a Links page, and then another when the PHP tracking script records its information. Two connections per page view seems a bit excessive.
Thanks in advance for any information or advice.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund