Yes, If you have a submit button or if you reload the page, the link is closed, excepted if you are using mysql_pconnect. (be aware of the timeout with mysql_pconnect - wait_timeout parameter in the my.cnf file - )
Jocelyn ----- Original Message ----- From: "markus|lervik" <[EMAIL PROTECTED]> To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 13, 2001 11:15 PM Subject: Re: [PHP] Performance > On Thu, 2001-12-13 at 23:56, Fournier Jocelyn [Presence-PC] wrote: > > Hi, > > > > You absolutely don't have to reconnect to the database each time a PHP-block > > ends ! (it would be completely awfull !!). > > Don't you forget to specify the mysql link in you 'mysql_query' ?? > > Nope, I always specify the mysql link in my queries. But the problem > remains. As I'm at home for the moment, I can't try out all the > suggestions, but I have tried the p_connect, and it most certanly didn't > work. I'll have to try to pinpoint the problem more closely tomorrow at > work. > > It just might be (came to think of it now), that php closes the > connection every time I use a submit-button and it reloads the page. > Technically speaking, that would be "ending a script", right? > > -Markus > > -- > Markus Lervik > Linux administrator with a kungfoo grip > Vasa City Library - Public Library > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
