mySQL overhead: Tweaking Scripts for Speed

From: Date: Fri, 05 Sep 2003 15:38:54 +0000
Subject: mySQL overhead: Tweaking Scripts for Speed
Groups: php.general 
Request: Send a blank email to php-general+get-161774@lists.php.net to get a copy of this message
I'm trying to figure out ways to tweak my scripts for performance. I've figured out that all mySQL queries should use indexed ids for speed. (For anyone who doesn't know: mySQL indexes fields with PRIMARY KEY, UNIQUE, or AUTO_INCREMENT in them. This means they're stored in binary trees internally, so access time is negligible for an INT PRIMARY KEY AUTO_INCREMENT). But how much overhead is there in: $link = mysql_connect($hostname,$username,$password) or die(""); $db = mysql_select_db($database,$link) or die(""); Would it be beneficial to run a single one at the beginning of every script? Currently I have a bunch of functions each with their own calls. Best Regards, Dan

« previous php.general (#161774) next »