Gossamer Forum
Home : Products : Gossamer Links : Discussions :

persistent mysql connections

Quote Reply
persistent mysql connections
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
Subject Author Views Date
Thread persistent mysql connections hennagaijin 1577 Nov 18, 2002, 5:40 AM
Thread Re: [hennagaijin] persistent mysql connections
Paul 1552 Nov 18, 2002, 5:49 AM
Thread Re: [Paul] persistent mysql connections
hennagaijin 1547 Nov 18, 2002, 5:51 AM
Thread Re: [hennagaijin] persistent mysql connections
Paul 1536 Nov 18, 2002, 6:16 AM
Post Re: [Paul] persistent mysql connections
hennagaijin 1526 Nov 18, 2002, 6:19 AM