UBB.Developers Forums UBB.threads 7 Development How Do I? > 30,000 users and performance?

Curious to know if others have boards with more than 30,000 users? I've been having some performance issues (mostly relating to using PALs) with my database of over 32,000 users.

I did a check and found that 15,000 of our users havent been active in the past year (three year board) - so I purged the database of those users and now I've gotten a significant boost in the performance of our board.

Maybe I need some tweaks to my MySQL configuration; but I was wondering how other people fared with large user databases.

From my experience, the amount of users doesn't affect the performance significantely.
We delete unactive users on a regular basis, so that we currently have about 10.000 entries. I did some testing with 20.000 and 30.000 users, but the query times increased very much.
The number of postings has much more influence on your performance, cause that's the biggest tables, with heavy load and some heavy queries (search, new post tracking) etc.

Yeah the posts table is where the big performance hit is. Once you reach a point close to our's you will need to either throw a good bit of hardware at it or modify the search some to be a little friendlier. We've done both.

1,134,367 rows
559.2 MB

Our posts table is not very large (about 9MB); but the user table was 15MB (not 8MB).

The main performance hit was on the "latest user" stat which was being generated - it query for that appeared to be causing some measurable delay.

The IIP Pals can cause heavy load, i don't recommend to use them on large boards.
We have about 900.000 posts in our db and run fine with 250 concurrent users online.

Hi,

Just wondering what kind of hardware you guys are running on that you can handle this much traffic.
We are running on a Netra 300MHz (dual processor) with 1Gb and have already run into speed problems. And that 6 months after upgrading.

As for the search, I think I read about that a few days ago, but can't find it anymore. What changes did you make?

Sanuk!

I'm using a normal Athlon 1200MHz, 1GB RAM and a EIDE-Raid.

I use MySQL 4.x and modified the search to benefit from the UNION statement (saves several full table scans) and the fulltext search with speeds up the search in post bodys.

Hi,

"I'm using a normal Athlon 1200MHz, 1GB RAM and a EIDE-Raid."
Sounds that in that case our server should easily be able to cope. Maybe there is a config problem?

"I use MySQL 4.x and modified the search to benefit from the UNION statement (saves several full table scans) and the fulltext search with speeds up the search in post bodys."
Could you send me the code changes you made? (I'm assuming these changes were made in the UBBT code, right?)

Sanuk!

For the modifications to really fly the best thing to tweak would be your mysql if your running version 4.012. This post and link by Jeremy will help you out.

https://ubbdev.com/forum/showfl...mp;Number=78372&Main=54670#Post78336

Hi,

Thanks. Info forwarded to my partner.

Sanuk!