Welcome, Guest. Please Login or Register.
August 29, 2025, 09:28:12 AM
Home Help Search Log in 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  |  English Help  |  Forum *MUCH* slower since upgrade from 1.1.0 « previous next »
Pages: 1 [2] Reply Ignore Print
Author Topic: Forum *MUCH* slower since upgrade from 1.1.0  (Read 573 times)
Hypocrite
YaBB God
*****
Posts: 692


For To End Yet Again

dimmuh@gmx.net WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #15 on: April 12, 2002, 03:50:46 PM »		 Reply with quote
Stupid question but how can you optimize tables?  :-[
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #16 on: April 12, 2002, 04:10:36 PM »		 Reply with quote
OPTIMIZE TABLE tablename;
Logged

My Amazon Wishlist
My Blog
Hypocrite
YaBB God
*****
Posts: 692


For To End Yet Again

dimmuh@gmx.net WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #17 on: April 12, 2002, 04:52:43 PM »		 Reply with quote
I guess it does the same when going into PHPMyAdmin and selecting all the tables and then choosing With selected -> Optimize tables :)
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #18 on: April 12, 2002, 05:54:19 PM »		 Reply with quote
Yep, helps to look around ;)
Logged

My Amazon Wishlist
My Blog
Greg Robson
Training to be like Joseph
YaBB SE Developer
YaBB God
*****
Posts: 1459


Hello!

ICQ - 81390136 WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #19 on: April 13, 2002, 01:37:37 PM »		 Reply with quote
It's like defragging you hard disk - you need to do it occasionally  :)

I think it should be built into the admin control panel for future versions ;)
Logged
You can't have everything... where would you put it? -- Steve Wright
Hypocrite
YaBB God
*****
Posts: 692


For To End Yet Again

dimmuh@gmx.net WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #20 on: April 13, 2002, 01:44:07 PM »		 Reply with quote
Could someone give me tips how to efficiently protect my PHPMyAdmin so that no outsiders can get messing with it? :) I already did the .htaccess and other stuff the install file suggested. Anything else?
Logged
Mach8
Sweetie
Beta Tester
YaBB God
*****
Posts: 1218


ICQ - 339855961
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #21 on: April 13, 2002, 03:27:39 PM »		 Reply with quote
I had another major problem, an important thread was refusing to load... I just took out the chunk of code which checks the image sizes and it loads fine now. I didn't need that anyway, not bothered how big the images are that my members post.
Logged
Jeff Lewis
Global Moderator
YaBB God
*****
Posts: 10149


I'm a llama!

WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #22 on: April 13, 2002, 03:59:32 PM »		 Reply with quote
Yeah some people may want to disable that as it even checks siganture images and can be quite intensive.
Logged

My Amazon Wishlist
My Blog
Greg Robson
Training to be like Joseph
YaBB SE Developer
YaBB God
*****
Posts: 1459


Hello!

ICQ - 81390136 WWW
Re:Forum *MUCH* slower since upgrade from 1.1.0
« Reply #23 on: April 13, 2002, 04:14:26 PM »		 Reply with quote
Quote from: Jeff Lewis on April 13, 2002, 03:59:32 PMYeah some people may want to disable that as it even checks siganture images and can be quite intensive.
Ouch - quite processor intensive - perhaps store in the database - perhaps it should only check the size if the avatar has changed?
Logged
You can't have everything... where would you put it? -- Steve Wright
Pages: 1 [2] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  Forum *MUCH* slower since upgrade from 1.1.0 « 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.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.660 seconds with 21 queries.