slow load time for arcade.php and high mysql load

[gamershell]

Hello, we're testing ibproarcade on our forums which are currently offline. We have around 150.000 users though the server is dedicated to the forums. We're seeing load go high and arcade.php taking various seconds to load and this is with just 3-4 admins looking around as they're not active to the public. Any idea what the cause could be? VB otherwise seems to be very quick and responsive, just arcade, most noticeably on homepage seems to slow down considerably.

thanks in advance

[MrZeropage]

having alot of users needs to follow some rules:

- do not display too many games per page
- save only users top score
- activate score-pruning (e.g. 7 or 14 days)

[gamershell]

we have save only top score
we are only 4 playing the games yet
I set it to 12 games per pages but even at 8 it wasn't visibly faster

any possible setup bug or any way to memcache results?

thanks again

[MrZeropage]

did you convert from an existing v3arcade or was it a fresh, clean and empty installation of ibProArcade ?

[gamershell]

did you convert from an existing v3arcade or was it a fresh, clean and empty installation of ibProArcade ?

fresh, clean and empty
v.2.6.6+
v.3.6.8 patch 2

thanks once more

--------------- Added 1202987973 at 1202987973 ---------------

another thing, listing games in admincp is blazin quick instead

[MrZeropage]

how many rows do you have in DB-table "games_scores" ?
how many games do you have installed ?

[gamershell]

92 in games_scores
around 40 games now and 6 categories

[MrZeropage]

this is a very SMALL installation, there are arcades having 10.000 users, about 500 games ect. and absolutely no problem.

Does a "play game"-page load faster ?

[gamershell]

I know it's small, I'm shocked seeing it slow, it doesn't really make sense; Games load quick, basically it's only index and index per category pages that are slow.

Would it be possible to memcache results? My worry is that getting server up, just a dozen people hitting arcade meantime will lead to a crash.

Can't the 150,000 users be the problem?

Which queries are relying on users on these pages, maybe some commenting out would do...?

--------------- Added 1203086376 at 1203086376 ---------------

removing the queries to ibf_members to fetch avatars made it quick loading