[PHP-DB] DB Connection Time

[E. Peter K. Chan]

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/akent2926.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 . 'brbr';
mssql_close($conn);
$timer-stop();
$timer-debug();
$timer-showtime();

Thanks

Peter



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] DB Connection Time

[E. Peter K. Chan]

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/akent2926.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 . 'brbr';
mssql_close($conn);
$timer-stop();
$timer-debug();
$timer-showtime();

Thanks

Peter



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]