Re: php with mssql
| From: | soff | Date: | Wed, 13 Nov 2002 07:35:53 +0000 |
| Subject: | Re: php with mssql | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-16916@lists.php.net to get a copy of this message | ||
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