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 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
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
wri
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 t
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 PROTECTED]">n
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?
Thir
We're only running one database on the system. The sample databases that
come with the software are still on there, but they're not being used at
all - this system is still in the testing stage. We're running an Athlon
1.2 GHz processor with 512 MB RAM.
"Gadam" <[EMAIL PROTECTED]> wrote in messa
uck a long delay, unless you SQL server is "overcrowded" with
other huge databases that you use...
George
-Original Message-
From: Michael Kroiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 3:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and MS SQL 2000 Per
We're running W2K, IIS 5, PHP 4, and SQL Server 2000 and performance seems
to be really slow. We're using a simple connect PHP script to query a table
that has only 1 record in it, and it takes approximately 20 seconds to load.
This seems to be very slow. Is this normal or does anyone have sugge
