 |
 |
Find a programming school near you
php3-list | 199903
Date: 03/30/99
- Next message: Stan Anderton: "RE: [PHP3] Joining tables in mySQL with PHP3"
- Previous message: Mark Heintz: "RE: [PHP3] holding HTTP_REFERER"
- In reply to: Shalendra Majmundar: "[PHP3] Good bye Sybase, Good bye mSql"
- Next in thread: pete collins: "Re: [PHP3] Good bye Sybase, Good bye mSql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Tue, 30 Mar 1999, Shalendra Majmundar wrote:
> I populate my php parsed page from Sybase. If I tap refresh a few times, it
> populates the screen, but then I get connection error to sybase. I have
> tried both persistent and non-persistent connections.
>
> To aggravate further, after a few refreshes, the sql server chokes. I guess
> it is that dirty-page/checkpoint issue, that I still need to clean up. But I
> can't login to the SQL server as an SA! Hell I have to kill and restart the
> server!!
In the case of persistent connections it looks like the infamous
connection-per-process problem -- after some number of requests the number
of connections to database exceeds the limits because all processes have
a connection. You can limit the number of all processes on the server to
the allowed number of simultaneous connections to the database (but then
you probably will need to run it as separate server), or you can
use fhttpd as a web server, and define scripts that use Sybase in separate
"Application" line with separate limit, like:
Application php-sybase - wwwuser 10 1 *.sybase.php3 /usr/local/sbin/php \
-s -u022 -t3600
Application php - wwwuser 500 1 *.php3 /usr/local/sbin/php -s -u022 -t3600
-- Alex---------------------------------------------------------------------- Excellent.. now give users the option to cut your hair you hippie! -- Anonymous Coward
-- PHP 3 Mailing List http://www.php.net/ To unsubscribe send an empty message to php3-unsubscribe <email protected> To subscribe to the digest list: php3-digest-subscribe <email protected> For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3 List administrator: zeev-list-admin <email protected>
- Next message: Stan Anderton: "RE: [PHP3] Joining tables in mySQL with PHP3"
- Previous message: Mark Heintz: "RE: [PHP3] holding HTTP_REFERER"
- In reply to: Shalendra Majmundar: "[PHP3] Good bye Sybase, Good bye mSql"
- Next in thread: pete collins: "Re: [PHP3] Good bye Sybase, Good bye mSql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
