Welcome, Guest. Please Login or Register.
November 23, 2017, 03:39:55 PM
Home Help Search Login Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  FAQ  |  Topic: Large message boards and MySQL logs of slow response « previous next »
Pages: 1 2 [3] 4 5 ... 10 Reply Ignore Print
Author Topic: Large message boards and MySQL logs of slow response  (Read 63032 times)
Greg Robson
Training to be like Joseph
YaBB SE Developer
YaBB God
*****
Posts: 1459


Hello!


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #30 on: April 14, 2002, 08:02:27 AM »
Reply with quote

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? :)
Logged

You can't have everything... where would you put it? -- Steve Wright
Mach8
Sweetie
Beta Tester
YaBB God
*****
Posts: 1218



Re:Large message boards and MySQL logs of slow response
« Reply #31 on: April 14, 2002, 10:07:40 AM »
Reply with quote

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.
Logged
mediman
Support Team
YaBB God
*****
Posts: 2858



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #32 on: April 14, 2002, 10:15:16 AM »
Reply with quote

my board have not so a slowdown (i havnt check the code, its 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
Logged

mainComm Dev Team
Mach8
Sweetie
Beta Tester
YaBB God
*****
Posts: 1218



Re:Large message boards and MySQL logs of slow response
« Reply #33 on: April 14, 2002, 10:27:12 AM »
Reply with quote

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?
« Last Edit: April 14, 2002, 10:36:56 AM by Mach8 » Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #34 on: April 14, 2002, 10:50:54 AM »
Reply with quote

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

mediman
Support Team
YaBB God
*****
Posts: 2858



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #35 on: April 14, 2002, 10:56:28 AM »
Reply with quote

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
Logged

mainComm Dev Team
Mach8
Sweetie
Beta Tester
YaBB God
*****
Posts: 1218



Re:Large message boards and MySQL logs of slow response
« Reply #36 on: April 14, 2002, 11:08:32 AM »
Reply with quote


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.
Logged
mediman
Support Team
YaBB God
*****
Posts: 2858



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #37 on: April 14, 2002, 11:14:38 AM »
Reply with quote

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 ill not have probs with disk quota *lol*
Logged

mainComm Dev Team
tore-
Sr. Member
****
Posts: 291


I love YaBB SE!


Re:Large message boards and MySQL logs of slow response
« Reply #38 on: April 14, 2002, 04:58:25 PM »
Reply with quote

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

Star wars rules!
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #39 on: April 14, 2002, 06:33:26 PM »
Reply with quote

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

AnalogDuck
Jr. Member
**
Posts: 54


I'm a Ducky! Quack quack...


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #40 on: April 15, 2002, 07:20:17 PM »
Reply with quote

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

Your work is greatly appreciated!   ;D
Logged

-- What does an "analog duck" sound like anyway?  That's the kind of noises I want to make... ;)
misteradio
Noobie
*
Posts: 7


"The roast beef combo's only $9.95."


WWW
Re:Large message boards and MySQL logs of slow response
« Reply #41 on: April 15, 2002, 10:15:00 PM »
Reply with quote

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.
Logged
RHiSC
Jr. Member
**
Posts: 96


I'm a llama!


Re:Large message boards and MySQL logs of slow response
« Reply #42 on: April 16, 2002, 06:48:44 AM »
Reply with quote

I do not have a clue about how to perform this task... can somebody do some real slow explaining to me?
Logged
tore-
Sr. Member
****
Posts: 291


I love YaBB SE!


Re:Large message boards and MySQL logs of slow response
« Reply #43 on: April 16, 2002, 08:56:10 AM »
Reply with quote


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
Logged

Star wars rules!
mediman
Support Team
YaBB God
*****
Posts: 2858



WWW
Re:Large message boards and MySQL logs of slow response
« Reply #44 on: April 16, 2002, 10:14:02 AM »
Reply with quote

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
Logged

mainComm Dev Team
Pages: 1 2 [3] 4 5 ... 10 Reply Ignore Print 
YaBB SE Community  |  English User Help  |  FAQ  |  Topic: Large message boards and MySQL logs of slow response « previous next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.0.12 | SMF © 2016, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.094 seconds with 19 queries.