I would simply make one connection to the db at the
top of your script befor your first DB call:
<?php
$intLink=mysql_connect();
$result=mysql_query("your query",$intLink);
?>
<html>
<head><title></title></head>
<body>
...output some php stuffs...
<?php
$result=mysql_query("another query",$intLink);
?>
...output some more php stuffs...
</body>
</html>
<?php
//destroy mysql connection and results
mysql_free_result($result);
mysql_close($intLink);
?>
//You really don't need the mysql_close(), but it is
//good practice, I suppose.
//Your ISP shouldn't close the mysql connection after every
//single php block. The php connection is closed at the
//end of your php script if you do not call mysql_close()
//before then.
//Also, $intLink is not required if you only make one
//connection to the database at a time.
---------------------
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-----Original Message-----
From: markus|lervik [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 2: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
