Hi. use mysql_pconnect. the manual page has a ton of info on using it to avoid the problem you're describing. http://ca.php.net/manual/en/function.mysql-pconnect.php
hth. -ravi -----Original Message----- From: markus|lervik [mailto:[EMAIL PROTECTED]] Sent: December 13, 2001 3:30 PM To: [EMAIL PROTECTED] Subject: RE: [PHP] Performance On Thu, 2001-12-13 at 22:16, Ron Jamison wrote: > I'm fairly sure there's no difference in performance when using PHP tags > mixed with HTML blocks as you are doing. > > Think of it as PHP knowing that it should send everything not in <? ?> tags > directly to the browser. Like an echo or a print, but without needing to > specify calls to those functions. > > <HTML> > <? echo $PHP_SELF ?> > </HTML> > > <HTML> > <?=$PHP_SELF?> > </HTML> I'm not -that- worried about performance loss for switching between, php and html, what annoys me (and would probably slow down performance quite a bit), is that every time I have to do a database query, I have to use mysql_connect again, because as Prottoss pointed out, PHP drops the connection every time a PHP-block ends. Not that it is that a big issue for my particular application, but knowing a workaround to this problem would be quite useful in the future. Cheers, 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 --------------------------------------------------------------------- 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
