DB Connection Time

From: Date: Sat, 21 Jul 2001 16:37:12 +0000
Subject: DB Connection Time
Groups: php.db 
Request: Send a blank email to php-db+get-10629@lists.php.net to get a copy of this message
Hi I am doing some script timing of a DB connection PHP/Linux to MSSQL thru FreeTDS based on this script timing article: http://www.phpbuilder.net/columns/akent20000926.php3 I am getting a time of 200-250 milliseconds compared to sub-50 ms using ASP/W2K/MSSQL. Any idea on what is generally acceptable for a small-medium db-driven website? How critical is this time? I am a bit concerned that accessing an MSSQL db from PHP/Linux is going to cause me headaches in a production environment. Any ideas on speeding it up? Here's my code if you want to try it out and report some results (of course results are dependent on hardware, network...) include ("phptimer.inc"); file://from the article above $timer = new PHP_timer; $timer->start(); $conn = mssql_connect($dbhost, $dbuser, $dbpass); mssql_select_db($dbname); echo $conn . '<br><br>'; mssql_close($conn); $timer->stop(); $timer->debug(); $timer->showtime(); Thanks Peter

« previous php.db (#10629) next »