[PHP-DB] DB Connection Time
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 . ''; 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
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 . ''; 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
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] DSO for odbc functions
Hi I've just installed RHL 7.1, and would like to test out the PHP4.0.6 ODBC functions. How can I get the DSO for this easily instead of recompiling. Is there a website I can download this extension from? 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] Production: Linux/Apache/PHP <--> FreeTDS <--> W2K/MSSQL 7.0
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]