"Too Many Connections" Error

[Ngreth Thergn]

I will talk to racknine about this tomorrow.

In the meantime... wait and come back.

Sorry for the inconvenience.

[Psychosis]

Terrabox offer is open to you. If you need it.

[Ngreth Thergn]

It is just a configuration matter.

Also phpBB seems to not be able to take the stress.

Plus... if I read the offer correctly... The offer from your President *may* be MORE expensive than what I am paying now. You may want to take this to PM's.

[Ahzzmandius]

PhpBB limits... ?

What kind of limits do you think that phpbb has that are causing you the problem?
Last time I checked it scaled pretty darn well of the boards out there.

[Ngreth Thergn]

It was part a change to pbpBB I made, and part that it just queries the database ALOT.

I had made a change that tracks the posts a user has read (the timestamp method phpBB uses is not real effective)

That hit the database even harder (alot harder) and everytime someone hit the index it went and searched every forum to see if you had read so it knew what icon to put up... it was rather inefficient. I have since backed out that change (it just wasn't ready for this size a board)

But racknine also increased the connection for me

[Ahzzmandius]

Ahhh. How about a "read_status" table. consists of forum, last_post_date, then each user has a last_read_date, forum_id table. If forum.last_post_date > user.last_read_date and user.forum == forum.forum_id then forum == unread_flagged.

When a user posts to a forum, the forum last_post_date gets updated. Thus keping a marker of when the last post to that forum was done.

Should be very efficient I beleive.

[Ngreth Thergn]

That sounds better than the one I was using...

Now to code that... eep! not gonna happen real soon (i was using someone elses code)

Also... the subforums add a new level of complexity