Support Forum
Support Forum
Offline
361; as in the wp_users and wp_sfmembers table...
Offline
I might be able to explain this although not necessarily effect a cure! The bad news is that it probably comes down to your rather large 297 forum records. I will explain..
You will have in your SP somewhere between 45 and 55 permission settings depending on what SP plugins you have installed. These are mapped to individual forums with their appropriate on/off settings. So there is one set per forum. For efficiency (and yes I really do mean that!) this mapping is cached in the sfmembers table. This means that is far quicker, by a very long way, to check any permission for the current user against any forum.
But.... say 50 permission records multiplied by 297 forums held in a php serialised array is an awful lot of data. And it probably accounts for the size of your sfmembers table. I am surprised by the size of your table but I reckon this is what is behind it.
If you then look at this the other way it has to be said that this will still be more efficient than building that complex map every time the page is run.
The first thing to do is optimise that table. I would also recommend you grab as much php memory as you can muster. And I will put n my thinking cap...
 |
YELLOW
SWORDFISH
|
Offline
Hello Andy,
you're definitly far more at home in the wp tables than i can hope to be - the weird thing is that the guest user seems the same content, but it loads faster by miles - although he's of course on a general "read only" access. I'll optimise the tables and send you the access to the mySQL admin (by mail); if that's alright with you.
thanks for your kind support to the both of you, best regards,
Ben
VIP
Offline
Andy, thanks for that DB info.
It's very interesting, and i learned something else today. I'm not much of a database admin, other than import or export that's about it.
This is a great friendly forum. 
- Doc ~ An old Fidonet SysOp. Just hanging out in cyberspace keeping up with tech.
Offline
Dosenben said
you're definitly far more at home in the wp tables than i can hope to be - the weird thing is that the guest user seems the same content, but it loads faster by miles - although he's of course on a general "read only" access. I'll optimise the tables and send you the access to the mySQL admin (by mail); if that's alright with you.
Received the credentials but the tables have not yet been optimised. I would feel more comfortable if you do that to be honest. Maybe perform a check table beforehand.
You really need to get the Db optimised first and then try running the forum again to see if this makes any difference.
|
YELLOW
SWORDFISH
|
Offline
FidoSysop said
Andy, thanks for that DB info.It's very interesting, and i learned something else today. I'm not much of a database admin, other than import or export that's about it.
This is a great friendly forum.
Thanks 
Sometimes it is hard to remember all of the wrinkles however!
|
YELLOW
SWORDFISH
|
Offline
Hey Andy;
finally we got around to optimizing the tables! Sorry for the delay. There's a noticeable improvement in the subforums; nevertheless the front page still loads painfully slow. If i could trouble you to take a look now (after we demolished out db 
); maybe you can see something we'd never notice.
best regards!
Ben
Offline
I don't believe there are any issues as such. I think this is all down to the caching which, of course, for 99.9% of users is a performance boost!
We will talk it over here to see if we can come up with anything that might help...
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)