In message <[EMAIL PROTECTED]>, Mike Brandonisio <[EMAIL PROTECTED]> writes >Hi, > >The connect simply connects and then closes the connection when done. >pconnect attempts to keep the connection open then you have to use a >script step to close the connection. For a script that uses one query >to MySQL connect is fine. For a script that uses multiple queries >pconnect can give you a performance boost by not having to negotiate >the connection for each query since the connection is persistent.
As I understand it, if the multiple queries are on the same page (same script, same .php file), then the connection is persistent within that page, using connect. pconnect carries the persistency across different pages. I use connect, I have never really looked at pconnect, probably simply because it 'feels' more complicated. You have to check that there is a connection, because not everyone enters my sites via the home page, so there is no-where obvious to place pconnect, and my websites have connections on most pages. I should really look at pconnect... -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
