-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, I remember reading of a config setting in php.ini which lowered the time PHP waits before clearing up/closing the socket out.
If it's a linux system you might want to try running netstat to see the open net connections. If you see lots of open connections when you reload the page a few times to your sql server then you know you need to shorten the appropiate timeouts. If you dont see lots of open connections then it's something unrelated to the actual virtual circuits opened. HTH, Dw. - ----- Original Message ----- From: "Justin Felker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: May 31 2002 11:21 PM Subject: Re: [PHP] MS SQL Problem > Thanks for the reply. Actually, I am using both mssql_free_query > and mssql_close along with mssql_pconnect. It still happens > however. I can post the code if you are unsure. Does it have a > history of threading issues as it only seems to happen when > several requests are sent all at once or at least in very fast > succession. > > Justin > > > At 06:56 PM 5/31/2002 -0700, you wrote: > >Hiya, > >were you using the appropriate free_query & close functions to > >free up the memory & more importantly the socket used to talk to > >the sql server? > > > >You might want to try using the _pconnect function if it's > >available instead of the usual _connect statement. > > > >I'd guess that PHP ran out of sockets to make outbound connections > >with. Also, I believe that MSSQL is setup to only have around 1000 > >max connections open unless you alter the value in the config. > > > >HTH, > >Dw > > > > > >Sqlcoders.com Dynamic data driven web solutions > >----- Original Message ----- > >From: "Justin Felker" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: May 31 2002 08:46 AM > >Subject: [PHP] MS SQL Problem > > > > > > > Last night, I ran into a problem when using the MS SQL support > > > in PHP > >under > > > Apache/PHP module/MS SQL 2000. Everything worked well enough. > > > I was able to connect to the server, query data, and a number > > > of other things. However, I found that if I ran my test page > > > (it connects to, queries and displays 20 rows of data, then > > > disconnects) over and over very quickly (hold CTRL+R down > > > basically) PHP would eventually (after about 6 seconds) fail to > > > connect to the MS SQL server. In fact, the web server would > > > have to be completely restarted before it could connect again. > > > > > > Has anyone run into this? I mean, if there is no solution to > > > this and is the cause of basically shaky MS SQL support, then > > > the SQL server would be made useless for sites with even a > > > modest amount of traffic (several requests per second). Is > > > this a known problem? If so, could anyone help me out? > > > > > > Thanks! > > > > > > Justin > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > >-- > >PHP General Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.5.8 iQA/AwUBPPljiNf2pW/GxlpVEQLy9wCg3tHovxdcVNthQvHyGY0brheJOqsAn28o yFtm2vp4juq7zFZcQy8G9Qfp =2jJv -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
