note 76559 added to function.odbc-connect

From: Date: Fri, 20 Jul 2007 13:39:25 +0000
Subject: note 76559 added to function.odbc-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-128761@lists.php.net to get a copy of this message
Hello there, I encounter a very strange performance behavior with using mssql server 2005 as localhost. I am using Apache2.2.4 (Win32) with PHP/5.2.3 on WinXP machine. Connecting to mssql at localhost using odbc. Driver={SQL Server}. The performace for queries is very poor. But when I run Microsoft SQL Management studio, open New Query, selecting the desired database, then the speed boosts up! When I close the Query, performance goes down as before. Does anyone knows why? How can I configure the server, or the connection, to such excelent performance as it is when the studio is opened? The performance is same when using odbc_connect or odbc_pconnect. ---- Server IP: 147.32.160.17 Probable Submitter: 193.179.187.70 ---- Manual Page -- http://www.php.net/manual/en/function.odbc-connect.php Edit -- https://master.php.net/note/edit/76559 Del: integrated -- https://master.php.net/note/delete/76559/integrated Del: useless -- https://master.php.net/note/delete/76559/useless Del: bad code -- https://master.php.net/note/delete/76559/bad+code Del: spam -- https://master.php.net/note/delete/76559/spam Del: non-english -- https://master.php.net/note/delete/76559/non-english Del: in docs -- https://master.php.net/note/delete/76559/in+docs Del: other reasons-- https://master.php.net/note/delete/76559 Reject -- https://master.php.net/note/reject/76559 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#128761) next »