Large message boards and MySQL logs of slow response

[Greg Robson]

Yes - I haven't checked the code myself - but would I be right in saying it verifies every post? If so then perhaps we only need to check when people change their avatar/signature?

[Mach8]

I think it checks avatars, signatures and attached images.

That caused a huge slowdown on my board as just about everyone has avatars and 75% of my members have images in their signatures. I think the feature should still be in there, but should be optionable.

[mediman]

my board have not so a slowdown (i havn´t check the code, it´s a php check (getimagesize) or javascript?

so or so i change my avatare code, the function to have a own avatar as a link is not so good for me (to slow servers or not answer form this servers, htaccess restrictet servers, deleted images and all this things)

i allow my user to use my avatars (in avatar directory) or to upload 1 Avatar, which will be resized and renamed, so when tehy upload anotherone the old one will be deletet!

medi

[Mach8]

Yeah it's done in PHP with the GD library.

I like the idea of having avatars stored locally, will you be releasing this as a mod?

[Jeff Lewis]

It works ok until you hit a slow server where an image is stored or one that isn't reachable at that time

[mediman]

yes it works!  but any user on my board use htaccess protectet images as avatars and this is not so kewl cause everytime i open a post twenty password things open same time! just for that i change it for me!

medi

[Mach8]

It works ok until you hit a slow server where an image is stored or one that isn't reachable at that time

That would have been it. One particular member has a sig that takes AGES to load, reasonable size etc but poor compression.

[mediman]

and this i try to prevent if i use an upload instead a link! and if every user has the abiltity to upload 1 image with a max. size of about 15 kb i think i´ll not have probs with disk quota *lol*

[tore-]

hmm, i didnt quite get this, is this an official fix or not?

[Jeff Lewis]

Sure  it works and we've applied it here so feel free...it's not going to harm your install.

[AnalogDuck]

Just so you know Greg, I'm excitedly awaiting the final conclusions of your exhaustive study!

Your work is greatly appreciated!  

[misteradio]

I, too, just applied this on a 1.3.0 (+ patches) install. I have a small board (350 users and about 3500 messages). I, too, noticed a speed improvement, although it was slight.

[RHiSC]

I do not have a clue about how to perform this task... can somebody do some real slow explaining to me?

[tore-]

I do not have a clue about how to perform this task... can somebody do some real slow explaining to me?

read all the post, then youll know, get phpmyadmin

[mediman]

for that people who have no phpmyadmin i can make a little script! (prhaps with analyzing, optimizing and repair tables if it is needed)

medi