[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]

Re: [PHP-DB] Date format in MSSQL

[E. Peter K. Chan]

Hi

Have a look in Books Online - the e-docs for MSSQL - search for the convert
function and all will be revealed.

Peter
- Original Message -
From: Jack [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 5:49 PM
Subject: [PHP-DB] Date format in MSSQL


 How I can format date in php query from MSSQL?

 Jack



 --
 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 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] Production: Linux/Apache/PHP -- FreeTDS -- W2K/MSSQL 7.0

[E. Peter K. Chan]

Hi

I am developing my website with this combo: W2K/IIS/PHP -- W2K/MSSQL7.0

When I switch to production I intend to use: Linux/Apache/PHP -- FreeTDS
-- W2K/MSSQL7.0

My question is this: Will I be able to use ALL the PHP MSSQL functions (as
listed in the PHP docs) when on the Linux combo?

I am particularly concerned about the mssql_next_result function (such a
function doesn't exist for Sybase and I don't know enough about how FreeTDS
works).

Thanks for your time

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]