Page 1 of 1

how many connections vs. queries ??

Posted: Fri Mar 29, 2002 10:04 pm
by eb kevin
So I am looking for technical specs of phpBB2.
I am looking at this host provide (www.dreamhost.com)
and you basically get a limit of what they call "Coneuries"
the forumla is (25 * connections) + queries = coneuries

So my question is, How often does MySQL open up a new connection? As you can see by this formula that would multiply and add up the server use pretty quick.

my board specs are 1,000 registered users; typically 15-25 users on the board 75% of the day, and around 500 posts a day.

Thanks to anyone who can answer

Posted: Fri Mar 29, 2002 10:08 pm
by hsim
well, every page view opens a connection to the database.

Posted: Fri Mar 29, 2002 10:16 pm
by eb kevin
Every single page you would load in phpBB creates a new connection?

Doesn't opening a closing connections to the database harder on the system then leaving an open connection? Or maybe i dont know what I'm talking about- just mostly relativly speaking from my little knowledge.

thanks for the help

Posted: Fri Mar 29, 2002 10:19 pm
by roly
open connections are actuly worse on the server

Posted: Fri Mar 29, 2002 10:24 pm
by Mercury
As far as I know you can't carry a database connection between executions of a script, so that's a fairly useless equation :roll: :?

Posted: Fri Mar 29, 2002 10:24 pm
by eb kevin
ok thanks gotcha. i dont know much on actual mysql databases and useage.