RE: [PHP-DB] PHP and MS SQL 2000 Performance
Ruprecht, SQLServer from Linux is pretty straightfoward. If you want full SQLServer2000 support, you will want to use ODBC. There is a HOWTO at www.iodbc.org for linking PHP --with-iodbc. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com 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 that from an other db-connectiontool. Has someone made > expearance with > using php-connections to a ms-sqlserver from a linux-box > (odbc-connections from > linux)? > > Regards, > Ruprecht > > -- > For germans > > > Vielleicht zufällig ein Projekt zu vergeben und nun auf der Suche > nach einem Freelancer? > Dann doch gleichmal vorbeischauen unter > http://www.gulp.de/profil/rhelms.html > > -- > > -- > 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]
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 that from an other db-connectiontool. Has someone made expearance with using php-connections to a ms-sqlserver from a linux-box (odbc-connections from linux)? Regards, Ruprecht -- For germans Vielleicht zufällig ein Projekt zu vergeben und nun auf der Suche nach einem Freelancer? Dann doch gleichmal vorbeischauen unter http://www.gulp.de/profil/rhelms.html -- -- 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] PHP and MS SQL 2000 Performance
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 written to SQL.LOG, slowing things down, so a simple query took 7 minutes. Joshua Hoover <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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? > > Third, is performance from an ODBC client and/or remote Query Analyzer > client slow performing the same queries? > > Fourth, did you check your SQL Server box and look at the activity on > it? Is SQL Server or some other service hogging resources? > > Thanks, > > Joshua Hoover > > > 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 message > > 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... > > MS SQL has generally very slow performance and is consuming a lot of > > system resources. Are you running any other databases on the SQL server, > > apart from the one you are querying? Could it be that your system has > > very small processing power? In any case, these possibilities wouldn't > > justify suck a long delay, unless you SQL server is "overcrowded" with > > other huge databases that you use... > > George > > > > > > > > -- > > 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]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
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 the Query Analyzer is extremely fast - pulls up 2000 records in like 3 seconds. Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? SQL Server is taking up about 40MB of memory, but not much of anything else going on. Thanks, Michael Thanks, Joshua Hoover > 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 message > 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... > MS SQL has generally very slow performance and is consuming a lot of > system resources. Are you running any other databases on the SQL server, > apart from the one you are querying? Could it be that your system has > very small processing power? In any case, these possibilities wouldn't > justify suck a long delay, unless you SQL server is "overcrowded" with > other huge databases that you use... > George > > > > -- > 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]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
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]">news:[EMAIL PROTECTED]... > 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? > > Third, is performance from an ODBC client and/or remote Query Analyzer > client slow performing the same queries? > > Fourth, did you check your SQL Server box and look at the activity on > it? Is SQL Server or some other service hogging resources? > > Thanks, > > Joshua Hoover > > > 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 message > > 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... > > MS SQL has generally very slow performance and is consuming a lot of > > system resources. Are you running any other databases on the SQL server, > > apart from the one you are querying? Could it be that your system has > > very small processing power? In any case, these possibilities wouldn't > > justify suck a long delay, unless you SQL server is "overcrowded" with > > other huge databases that you use... > > George > > > > > > > > -- > > 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]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
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? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover > 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 message > 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... > MS SQL has generally very slow performance and is consuming a lot of > system resources. Are you running any other databases on the SQL server, > apart from the one you are querying? Could it be that your system has > very small processing power? In any case, these possibilities wouldn't > justify suck a long delay, unless you SQL server is "overcrowded" with > other huge databases that you use... > George > > > > -- > 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]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
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 message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is "overcrowded" with other huge databases that you use... George -- 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] PHP and MS SQL 2000 Performance
MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck 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 Performance 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 suggestions how to speed things up? Thanks! -- 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]
