how many connections vs. queries ??

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
eb kevin
Registered User
Posts: 53
Joined: Fri Aug 24, 2001 6:00 am
Location: las vegas
Contact:

how many connections vs. queries ??

Post by eb kevin » Fri Mar 29, 2002 10:04 pm

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

hsim
Registered User
Posts: 1554
Joined: Tue Oct 23, 2001 9:39 pm
Contact:

Post by hsim » Fri Mar 29, 2002 10:08 pm

well, every page view opens a connection to the database.
email me: hsim at gmx.li

eb kevin
Registered User
Posts: 53
Joined: Fri Aug 24, 2001 6:00 am
Location: las vegas
Contact:

Post by eb kevin » Fri Mar 29, 2002 10:16 pm

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

User avatar
roly
Registered User
Posts: 775
Joined: Fri Jan 04, 2002 7:13 am
Location: Australia

Post by roly » Fri Mar 29, 2002 10:19 pm

open connections are actuly worse on the server

Mercury
Registered User
Posts: 6
Joined: Sat Jan 26, 2002 8:23 pm
Location: New Jersey, USA
Contact:

Post by Mercury » Fri Mar 29, 2002 10:24 pm

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: :?
Jason Warner
MercuryBoard Author

eb kevin
Registered User
Posts: 53
Joined: Fri Aug 24, 2001 6:00 am
Location: las vegas
Contact:

Post by eb kevin » Fri Mar 29, 2002 10:24 pm

ok thanks gotcha. i dont know much on actual mysql databases and useage.

Locked

Return to “2.0.x Support Forum”