Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-07 Thread steve
Thanks! That is a blast from the past! I never got it working properly, and since using PHP in FastCGI mode has eliminated the problem by 80%+, hopefully I won't have to revisit it. But thanks again! I never know! -s On 2/7/07, Reinis Rozitis <[EMAIL PROTECTED]> wrote: > Christopher Jones wrote

Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-07 Thread steve
On 2/6/07, Rasmus Lerdorf <[EMAIL PROTECTED]> wrote: A couple of points. mysqli doesn't have persistent connections because the authors of that particular extension don't think it is a good idea. It's not a PHP-wide thing, PDO and others do have it. Yes, point taken. I just figured they were

Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-07 Thread Reinis Rozitis
Christopher Jones wrote: I guess MySQL folks are also looking into Java like connection pooling: http://krow.livejournal.com/487174.html Besides there are some third-party solutions like SQLRelay http://sqlrelay.sourceforge.net/ rr -- PHP Internals - PHP Runtime Development Mailing List To

Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-07 Thread steve
Having cross-process persistent connection pool for PDO would be great. Having a better system on the DB side would be great too (as it looks to be for Oracle). The MySQL server test looks promising. I like the Apache 2.2 model of using epoll to have one thread handle all the keep-alive connectio

Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-06 Thread Rasmus Lerdorf
A couple of points. mysqli doesn't have persistent connections because the authors of that particular extension don't think it is a good idea. It's not a PHP-wide thing, PDO and others do have it. If you are going to FastCGI for performance and scalability reasons because you don't want a heavyw

Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-06 Thread Lukas Kahwe Smith
Christopher Jones wrote: steve wrote: > Oh, and allow persistent connections in db apis again (like mysqli). It might happen. Wez Furlong was contemplating a persistent connection implementation for the generic PDO interface following on from the persistent connection model in the oci8 extensi

Re: [PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-06 Thread Christopher Jones
steve wrote: > Oh, and allow persistent connections in db apis again (like mysqli). It might happen. Wez Furlong was contemplating a persistent connection implementation for the generic PDO interface following on from the persistent connection model in the oci8 extension for Oracle. > As an exa

[PHP-DEV] mod_fast_apache, FastCGI, and mysqli

2007-02-06 Thread steve
From my experience with PHP over the years, in setups with both low and high traffic, I'd like to humbly put out a suggestion: have PHP include its own FastCGI SAPI in PHP 5.x and make it the default/recommended in PHP 6. Oh, and allow persistent connections in db apis again (like mysqli). The c