Hi Pete, Yes, you are correct. It is per script. I was incorrect.
-- Mike Brandonisio * Web Hosting Tech One Illustration * Database Applications tel (630) 759-9283 * e-Commerce [EMAIL PROTECTED] * http://www.jikometrix.net JIKOmetrix - Reliable web hosting On May 30, 2005, at 2:39 AM, Pete wrote: > 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: php-list@yahoogroups.com > 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 > > > > > > > > > Community email addresses: Post message: php-list@yahoogroups.com 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/