[PHP-DB] PHP and MS SQL Server 7.0
I would like to use PHP to open a connection to a MS SQL server, query the database, and then use the query results to generate dynamic content for a mass HTML e-mail campaign. Is it possible to execute PHP scripts in an HTML file or must the file have a .php extension? I'm limited by the software my employer uses (UnityMail, maybe someone's familiar with it?) which requires that the HTML code for the message body be pasted into a client-side form that the software then uses to generate the message and deliver it to the list of recipients. Any help is greatly appreciated! Cheers, Michael Morrison Valparaiso University http://www.therainforestsite.com/ http://www.thehungersite.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Thanks Frank! -Original Message- From: Frank M. Kromann [mailto:frank@;kromann.info] Sent: Sunday, October 27, 2002 4:22 AM To: Axel Bergmann; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info: Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server. These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work. One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...). - Frank > Thanks John! > Say, are there any arguments not to use MS-SQL? > Did you run into any problems? > > Thanks, > Axel > > -Original Message- > From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] > Sent: Friday, October 25, 2002 3:14 PM > To: Axel; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] PHP and MS-SQL > > Axel, > > Well, I'm not sure what everyone will tell you, but this is what I did. I >used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" >PHP functions. There is also the matter of changing your SQL Statements to be >compatible with SQL Server. MySQL and SQL Server have quite a few differences with >SQL Statements. As far as the rest of your code, it should not matter if it's on >UNIX or Windows. > > John Negretti > Web Applications Developer > Cox Communications www.cox.com > > > > -Original Message- > > From: Axel [mailto:bergmann@;hi.net] > > Sent: Friday, October 25, 2002 6:57 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] PHP and MS-SQL > > > > > > I want to apologize for my ignorance in advance... > > I'm developing PHP code with MySQL on Unix platforms for > > quite a while. Now > > I'm asked to use my unix based PHP code with a MS-SQL database on a > > Microsoft platform. So while having the php code on a unix > > platform the > > MS-SQL database is obviously sitting on a Microsoft platform. > > Can this work > > and if so how can I do this? > > > > Thanks, > > Axel > > __ > > Axel > > Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me > > __ > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and MS-SQL
Hello, OpenLink provides single-tier ODBC Drivers for MS SQL Server from Mac OS X - these support the additional data types and will work against either Sybase ASE or MS SQL Server, on any platforms they run on. 30-day downloads are available from our site at http://www.openlinksw.com Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Sunday, October 27, 2002, at 12:22 AM, Frank M. Kromann wrote: Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info: Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server. These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work. One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...). - Frank Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows. John Negretti Web Applications Developer Cox Communications www.cox.com -Original Message- From: Axel [mailto:bergmann@;hi.net] Sent: Friday, October 25, 2002 6:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MS-SQL I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info: Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server. These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work. One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...). - Frank > Thanks John! > Say, are there any arguments not to use MS-SQL? > Did you run into any problems? > > Thanks, > Axel > > -Original Message- > From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] > Sent: Friday, October 25, 2002 3:14 PM > To: Axel; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] PHP and MS-SQL > > Axel, > > Well, I'm not sure what everyone will tell you, but this is what I did. I >used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" >PHP functions. There is also the matter of changing your SQL Statements to be >compatible with SQL Server. MySQL and SQL Server have quite a few differences with >SQL Statements. As far as the rest of your code, it should not matter if it's on >UNIX or Windows. > > John Negretti > Web Applications Developer > Cox Communications www.cox.com > > > > -Original Message- > > From: Axel [mailto:bergmann@;hi.net] > > Sent: Friday, October 25, 2002 6:57 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] PHP and MS-SQL > > > > > > I want to apologize for my ignorance in advance... > > I'm developing PHP code with MySQL on Unix platforms for > > quite a while. Now > > I'm asked to use my unix based PHP code with a MS-SQL database on a > > Microsoft platform. So while having the php code on a unix > > platform the > > MS-SQL database is obviously sitting on a Microsoft platform. > > Can this work > > and if so how can I do this? > > > > Thanks, > > Axel > > __ > > Axel > > Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me > > __ > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Great, thanks a bunch!
-Original Message-
From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke@;Keane.com]
Sent: Friday, October 25, 2002 3:11 PM
To: Axel
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP and MS-SQL
yes this works. if your code is going to remian on Unix you'll have to
install freetds (www.freetds.org). there are instructions on
www.php.net/mssql for install in the comments...
when you get to the site(freetds.org) I know it says Sysbase..but it is
what you're looking for.
hope this helps
jd
"Axel"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
et> cc:
Subject: [PHP-DB] PHP and MS-SQL
10/25/2002
09:57 AM
I want to apologize for my ignorance in advance...
I'm developing PHP code with MySQL on Unix platforms for quite a while. Now
I'm asked to use my unix based PHP code with a MS-SQL database on a
Microsoft platform. So while having the php code on a unix platform the
MS-SQL database is obviously sitting on a Microsoft platform. Can this work
and if so how can I do this?
Thanks,
Axel
__ Axel
Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me
__
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows. John Negretti Web Applications Developer Cox Communications www.cox.com > -Original Message- > From: Axel [mailto:bergmann@;hi.net] > Sent: Friday, October 25, 2002 6:57 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP and MS-SQL > > > I want to apologize for my ignorance in advance... > I'm developing PHP code with MySQL on Unix platforms for > quite a while. Now > I'm asked to use my unix based PHP code with a MS-SQL database on a > Microsoft platform. So while having the php code on a unix > platform the > MS-SQL database is obviously sitting on a Microsoft platform. > Can this work > and if so how can I do this? > > Thanks, > Axel > __ > Axel > Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me > __ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows. John Negretti Web Applications Developer Cox Communications www.cox.com > -Original Message- > From: Axel [mailto:bergmann@;hi.net] > Sent: Friday, October 25, 2002 6:57 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP and MS-SQL > > > I want to apologize for my ignorance in advance... > I'm developing PHP code with MySQL on Unix platforms for > quite a while. Now > I'm asked to use my unix based PHP code with a MS-SQL database on a > Microsoft platform. So while having the php code on a unix > platform the > MS-SQL database is obviously sitting on a Microsoft platform. > Can this work > and if so how can I do this? > > Thanks, > Axel > __ > Axel > Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me > __ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and MS-SQL
yes this works. if your code is going to remian on Unix you'll have to
install freetds (www.freetds.org). there are instructions on
www.php.net/mssql for install in the comments...
when you get to the site(freetds.org) I know it says Sysbase..but it is
what you're looking for.
hope this helps
jd
"Axel"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
et> cc:
Subject: [PHP-DB] PHP and MS-SQL
10/25/2002
09:57 AM
I want to apologize for my ignorance in advance...
I'm developing PHP code with MySQL on Unix platforms for quite a while. Now
I'm asked to use my unix based PHP code with a MS-SQL database on a
Microsoft platform. So while having the php code on a unix platform the
MS-SQL database is obviously sitting on a Microsoft platform. Can this work
and if so how can I do this?
Thanks,
Axel
__ Axel
Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me
__
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and MS-SQL
I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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]
[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]
