XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / MySQL simultaneous connections
Register
1
auroramae
MySQL simultaneous connections

  • 2005/10/8 13:28

  • auroramae

  • Just popping in

  • Posts: 4

  • Since: 2005/10/2


I've installed XOOPS and having a good time trying modules, themes etc. Awesome program!! Very easy installation!

I've been keeping tack of how many queries are made browsing through the blocks.

My host states that it allows 50 simultaneous connections.

The front Page Load Statistics: 2.966 Seconds | 34 Queries
I can remove content but I like what I've chosen.

my question-
If two users load the page at exactly the same time, will one will get an error or will the loading process just take longer for one -- is it queued?

50 seems restrictve when a page uses 34 to load.

Please excuse my total lack of knowledge on this subject.
I am clueless.

auroramae
2
jdseymour
Re: MySQL simultaneous connections

Just a suggestion. If you have some content that is static, or virtually static (not changed much), and if you cache the content or blocks it will reduce the number of queries.

And yes, I would consider a number of 50 connections rather restrictive, but that is an agreement between you and your host. You can however shop around for a less restrictive provider.
3
LazyBadger
Re: MySQL simultaneous connections

Damned hell!!!Connection != Queries per page
50 simultaneous connection means, what it's possible to have 50 visitors on site at the same time (if persistent connection disabled), and probably slightly more (plus permanent complaints from provider for opened stalled connections) if persistent connection in XOOPS enabled.

Cache reduces QUERIES per page, not connection amount!
Quis custodiet ipsos custodes?

Webmaster of
XOOPS2.RU
XOOPS Modules Proving Ground
XOOPS Themes Exhibition
4
JMorris
Re: MySQL simultaneous connections

  • 2005/10/8 14:49

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


LB,

Please try to not use profane language. And please try to be a little nicer. This kind of thing is getting out of hand.

More info: XOOPSiquette

Best Regards,

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.
5
auroramae
Re: MySQL simultaneous connections

  • 2005/10/8 20:21

  • auroramae

  • Just popping in

  • Posts: 4

  • Since: 2005/10/2


Helo again,

Thanks for taking the time to answer. Although it seems the question has annoyed you just a tiny bit.


Quote:

50 simultaneous connection means, what it's possible to have 50 visitors on site at the same time (if persistent connection disabled


I contacted my host before I posted the question and they stated that their policy means 50 queries not fifty visitors. Perhaps I should have mentioned that in my first message.

Thank you both for the tips regarding cache and persistent connection. I'd wondered if that would need to be taken into account.

Auroramae

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

195 user(s) are online (22 user(s) are browsing Support Forums)

Members: 1

Guests: 194

heyula,

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits