Am Mon, 19 Nov 2001 schrieb John Lim:
Are you using ODBC? We recently had similar problems, and it turned out that
we
had SQL tracing enabled, and every single ODBC function call was being
written
to SQL.LOG
And added, such a traced logfile can grow up to some megabyte of data.
I know
Universal Data Access Data Integration Technology Providers
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 3:11 PM
To: John Lim; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP and MS SQL 2000 Performance
Am Mon, 19 Nov 2001 schrieb
I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5
and a variety of other services (including the PHP cgi) and have not
seen any type of performance problems.
First, are you using the mssql.dll to connect or ODBC?
Second, are you running PHP as a cgi or ISAPI plug-in?
Are you using ODBC? We recently had similar problems, and it turned out that
we
had SQL tracing enabled, and every single ODBC function call was being
written
to SQL.LOG, slowing things down, so a simple query took 7 minutes.
Joshua Hoover [EMAIL PROTECTED] wrote in message
[EMAIL
First, are you using the mssql.dll to connect or ODBC?
Using mssql.dll
Second, are you running PHP as a cgi or ISAPI plug-in?
As a CGI under the Home Directory tab
Third, is performance from an ODBC client and/or remote Query Analyzer
client slow performing the same queries?
Performance from
I'm using the php_mssql.dll extension/connection.
John Lim [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Are you using ODBC? We recently had similar problems, and it turned out that
we
had SQL tracing enabled, and every single ODBC function call was being