On Mon, 30 Oct 2000, Johan Isacsson wrote:
> Is anyone using it with MySQL and have more than 150 connections, and if
> so, do you use some kind of pooling technique? Does it work well/is it
> stable?
pooling generally helps, but mysql connections are little more then tcp
sockets, so their overhead isn't as great as lets say an oracle
connection. Pooling might be a disadvantage also because of leaks
(ie: programming bugs in drivers/bindings/custom code) that are getting
eliminated currently because of connections getting recycled constantly.
Also, you have to put java sql connections over tcp (ie: no
shared memory), so this might be a disadvantage for you if you don't use
tcp for mysql connections today.
Another thing that jsp/java has over php is a common jdbc language, so if
you move to a different database, you will not have to rewrite any
code.. if you look at the php api for different databases, it can be
annoying to port... depending on how you code is organized.
Also, I suspect your bottleneck is mysql, as it does table level locking,
but this would only appear if the tables tend to be written to.
But, I haven't done a migration from php->jsp, or use mysql, or have a jsp
based site that get's that many hits.
HTH,
Kenneth Topp
---
to unsubscribe: [EMAIL PROTECTED]
for more info: http://jakarta.apache.org/getinvolved/mail.html
>
> As i mentioned before we run PHP with MySQL today and we're having a hard
> time to scale it. We have about 10 dedicated Web/DB machines (2x800
> MHz, 1 G RAM) running our sites and we need to get more soon. We
> have about 13 million pageloads a day (about 120 million hits) That's why
> i'm looking at alternatives such as JSP. I'd love to get some comments
> from people that have migrated from PHP (if there are any) :)
>
> Thanks,
> Johan Isacsson
>
