Honestly - I have no idea how to do this in MSSQL. Those instructions are
for limiting the Apache server.
The mssql_connect shouldn't be an issue because the connection is torn
down when the php page is done (or mssql_close (?) is called), but you
said you have experienced issues with that call.
-Dash
A computer, to print out a fact,
Will divide, multiply, and subtract.
But this output can be
No more than debris,
If the input was short of exact.
-- Gigo
On Wed, 13 Nov 2002, soff wrote:
> Sigh...
>
> I seems so difficult :(
>
> How about the normal connect :P
>
> Thanks
>
> 您在 Tue, 12 Nov 2002 23:25:27 -0800 (PST) 的来信中提到:
>
> > This could be the configuation entry for Apache2 on Win2k:
> >
> > http://httpd.apache.org/docs-2.0/mod/mpm_common.html#threadsperchild
> >
> > Or this:
> >
> > http://httpd.apache.org/docs-2.0/mod/mpm_common.html#maxclients
> >
> > If not, look here:
> >
> > http://httpd.apache.org/docs-2.0/mod/quickreference.html
> >
> > and search for Max. You're bound to find something.
> >
> > My database stuff uses pconnect as well. I've never timed it or anything,
> > but it just seems to make more sense to do so.
> >
> > -Dash
> >
> > Never make anything simple and efficient when a way can be found to
> > make it complex and wonderful.
> >
> > On Wed, 13 Nov 2002, soff wrote:
> >
> > > Dash,
> > >
> > > Thanks for you answer, my env is Win2000 Server + php lastest STABLE +
> > > Aapache 2.0.43 + MS SQL Server 2000(SP2). Can you tell me how to
> > > configure the max threads and let mssql_pconnect() work well. It think
> > > that mssql_pconnect() will be better than mssql_connect() if they both
> > > work well :P
> > >
> > >
> > > At Tue, 12 Nov 2002 23:04:43 -0800 (PST), You Write:
> > >
> > > > Soff,
> > > >
> > > > What web server are you using? I know that if you use Apache (which has a
> > > > max threads (?) paramater of 150) against MySQL (default: 100) and
> > > > pconnect, the database can start to deny new connections. You may be
> > > > running into the same issue here. Look at your max number of connections.
> > > >
> > > > I have no idea why INSERT/UPDATE queries wouldn't work with a normal
> > > > connect. I'm not an MSSQL user...
> > > >
> > > > p.s. don't worry about your english. You type it better than most
> > > > americans I know...
> > > >
> > > > -Dash
> > > >
> > > > In a five year period we can get one superb programming language. Only
> > > > we can't control when the five year period will begin.
> > > >
> > > > On Wed, 13 Nov 2002, soff wrote:
> > > >
> > > > > hello,
> > > > >
> > > > > I am trying to connect mssql with php, when I use mssql_pconnect(), It
> > > > > will fail to connect when the amount of visitors becomes large. But,
> > > > > when I use mssql_connect(), I can only run SELECT quern, while the
> > > > > INSERT/UPDATE staments doesn't work. Can somebody tell me why? thanks
> > > > > and sorry for my poor English :P
> > > > > --
> > > > > Welcome to http://www.soff.net
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > PHP Windows Mailing List (http://www.php.net/)
> > > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > > >
> > > > >
> > > >
> > >
> > > --
> > > Welcome to http://www.soff.net
> > >
> > >
> > >
> > > --
> > > PHP Windows Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
>
> --
> Welcome to http://www.soff.net
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
