Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stanislav Malyshev
If you interested in further improving performance, look at bytecode caches such as Zend Platform or APC. It can be especially beneficial if you use frameworks containing a lot of PHP classes. As I already mentioned, I used eAccelerator. Does APC perform better? No idea about eAccelerator, did

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stanislav Malyshev
OK, I installed FCGI and ran my testsuite. I did get more requests in a timeperiod of 5 minutes, but unfortunatly I also got a lot of errors (HTTP 500). But the performance of successful pages was increased by almost 15%. Maybe you need to configure FastCGI for more processes - 500 could be res

RE: [PHP-WIN] PHP & SQL Server 2005

2007-04-25 Thread Gustav Wiberg
Hi again! Maybe it's something about rights for the IUSR? Else I don't know... Best regards /Gustav Wiberg -Original Message- From: Dale Attree [mailto:[EMAIL PROTECTED] Sent: Thursday, April 26, 2007 8:37 AM To: 'Gustav Wiberg' Subject: RE: [PHP-WIN] PHP & SQL Server 2005 It is a b

RE: [PHP-WIN] PHP & SQL Server 2005

2007-04-25 Thread Gustav Wiberg
Hi again Is it the the same with updates? Maybe its something about limitation in table? http://blogs.msdn.com/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2000-and-2005.aspx Best regards /Gustav Wiberg -Original Message- From: Dale Attree [mailto:[EMAIL PROTECTED] Sent: Thurs

RE: [PHP-WIN] PHP & SQL Server 2005

2007-04-25 Thread Gustav Wiberg
Hi there! "$RP = $_SERVER['REQUEST_URI'];" Shouldn't this be $RP = $_SERVER['REQUEST_URL']; ? Best regards /Gustav Wiberg -Original Message- From: Dale Attree [mailto:[EMAIL PROTECTED] Sent: Thursday, April 26, 2007 8:13 AM To: 'Alf Stockton' Cc: php-windows@lists.php.net Subject: RE:

RE: [PHP-WIN] PHP & SQL Server 2005

2007-04-25 Thread Dale Attree
$RP = $_SERVER['REQUEST_URI']; $res = mssql_query($sql,$dblink) or die($RP.''.mssql_get_last_message()); It is hitting the die() and therefore not inserting into the DB. -Original Message- From: Alf Stockton [mailto:[EMAIL PROTECTED] Sent: 26 April 2007 08:06 AM To: Dale Attree Cc: php-

Re: [PHP-WIN] PHP & SQL Server 2005

2007-04-25 Thread Alf Stockton
Dale Attree wrote: Hi guys. I am able to do select queries without any hassles, but as soon as I try execute an insert query, I get "The statement has been terminated." Any suggestions? The "The statement has been terminated." does not necessarily mean that the insert failed. Look in

[PHP-WIN] PHP & SQL Server 2005

2007-04-25 Thread Dale Attree
Hi guys. I am able to do select queries without any hassles, but as soon as I try execute an insert query, I get "The statement has been terminated." Any suggestions? Kind Regards, Dale ***

[PHP-WIN] Re: MySQL + SSL with PHP on windows

2007-04-25 Thread Adam Madsen
I have been having the same issue. Using PHP 5.2.1 mysql or mysqli I can not connect to a remote Mysql server using SSL I can get it to work on a mysql command line client just not with PHP. Has anyone ever had this working on an IIS box? Adam Madsen -- IT Director Transwest Gr

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Richard Lynch
On Wed, April 25, 2007 4:45 am, Zoltán Németh wrote: > 2007. 04. 25, szerda keltezéssel 11.33-kor Henning Eiben ezt írta: >> Hi, >> >> I wrote a small sample-application once using PHP (with propel and >> smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps >> are >> being served

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Stanislav Malyshev wrote: >> OK, so I will give that a try. As far as I understand, I basically just >> have to replace the association of ".php" to "php5isapi.dll" with >> "php-cgi.exe"; and then set the global path to include my php-folder, >> right? > > No, that probably would make it CGI, whi

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Stanislav Malyshev wrote: > If you interested in further improving performance, look at bytecode > caches such as Zend Platform or APC. It can be especially beneficial if > you use frameworks containing a lot of PHP classes. As I already mentioned, I used eAccelerator. Does APC perform better?

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stanislav Malyshev
OK, so I will give that a try. As far as I understand, I basically just have to replace the association of ".php" to "php5isapi.dll" with "php-cgi.exe"; and then set the global path to include my php-folder, right? No, that probably would make it CGI, which is slow. For FastCGI, you need FastCG

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Stanislav Malyshev wrote: >> OK; so for serving multiple concurrent clients ISAPI would sound to me >> like the better choice, since it can use threads, or what would be the >> advantage of using fastcgi? > > Non-threaded PHP is faster than threaded PHP, because it doesn't need to > do locks betw

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stanislav Malyshev
OK; so for serving multiple concurrent clients ISAPI would sound to me like the better choice, since it can use threads, or what would be the advantage of using fastcgi? Non-threaded PHP is faster than threaded PHP, because it doesn't need to do locks between threads and keep the thread context

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Stanislav Malyshev wrote: >> But as far as I understand, java kinda does the same thing, doesn't it? >> Java programs are being compiled into some intermediate language, and >> this is being interpreted at runtime. So using an accelerator should >> mimic the same setup for php. > > Java is much l

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stanislav Malyshev
But as far as I understand, java kinda does the same thing, doesn't it? Java programs are being compiled into some intermediate language, and this is being interpreted at runtime. So using an accelerator should mimic the same setup for php. Java is much less dynamic language than PHP (try doing

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Zoltán Németh wrote: I wrote a small sample-application once using PHP (with propel and smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are being served from a windows server (2x Xeon 1,3GHz, 2 GB RAM), but the performance of the PHP version is much slower

Re: [PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stanislav Malyshev
OK, so FastCGI is much better than ISAPI? Looking quickly at the Not exactly so - the thing here is that non-threadsafe PHP is faster than threadsafe PHP - since no inter-thread locking is necessary. And since ISAPI PHP must be TS and FastCGI PHP can be non-TS - the FastCGI PHP ends up being

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Zoltán Németh wrote: I already installed an php-accelerator (eAccelator) which increased the overall performance, but still the performance is quite poor. >>> I would not say php performace is poor, I think it is quite fast (at >>> least on my linux boxes, I know nothing about php on win

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Zoltán Németh
2007. 04. 25, szerda keltezéssel 11.53-kor Henning Eiben ezt írta: > Zoltán Németh schrieb: > > >> I wrote a small sample-application once using PHP (with propel and > >> smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are > >> being served from a windows server (2x Xeon 1,3GH

Re: [PHP-WIN] Regular expression

2007-04-25 Thread Kevin Smith
A little more precise to what you asked for: Mikael Grön wrote: Hey all! I'm in panic! I need a regex that returns true on strings containing both 'update' and 'where 1 = 1'. Both must be case insensitive and there might be spaces between the 1's and the '=', and there might not.. Some nitw

Re: [PHP-WIN] Regular expression

2007-04-25 Thread Kevin Smith
Here's a very simple one I just knocked out in a few seconds: Mikael Grön wrote: Hey all! I'm in panic! I need a regex that returns true on strings containing both 'update' and 'where 1 = 1'. Both must be case insensitive and there might be spaces between the 1's and the '=', and there migh

[PHP-WIN] Regular expression

2007-04-25 Thread Mikael Grön
Hey all! I'm in panic! I need a regex that returns true on strings containing both 'update' and 'where 1 = 1'. Both must be case insensitive and there might be spaces between the 1's and the '=', and there might not.. Some nitwit chose to build the database functions of the site I'm working on

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Zoltán Németh schrieb: >> I wrote a small sample-application once using PHP (with propel and >> smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are >> being served from a windows server (2x Xeon 1,3GHz, 2 GB RAM), but the >> performance of the PHP version is much slower than t

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Zoltán Németh
2007. 04. 25, szerda keltezéssel 11.33-kor Henning Eiben ezt írta: > Hi, > > I wrote a small sample-application once using PHP (with propel and > smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are > being served from a windows server (2x Xeon 1,3GHz, 2 GB RAM), but the > perf

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Henning Eiben
Stut schrieb: >> I wrote a small sample-application once using PHP (with propel and >> smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are >> being served from a windows server (2x Xeon 1,3GHz, 2 GB RAM), but the >> performance of the PHP version is much slower than the Java v

[PHP-WIN] Re: [PHP] slow performance

2007-04-25 Thread Stut
Henning Eiben wrote: I wrote a small sample-application once using PHP (with propel and smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are being served from a windows server (2x Xeon 1,3GHz, 2 GB RAM), but the performance of the PHP version is much slower than the Java versi

[PHP-WIN] slow performance

2007-04-25 Thread Henning Eiben
Hi, I wrote a small sample-application once using PHP (with propel and smarty) and once using Java (JBoss, EJB3, JSP & Servlets). Both apps are being served from a windows server (2x Xeon 1,3GHz, 2 GB RAM), but the performance of the PHP version is much slower than the Java version. I already ins