Twenty-four things you can do to make SMF go faster (Updated June 16th, 2010)

[Owdy]

Yes, I would still convert, but I wouldn't convert all your tables, just the suggested ones. You'll get a benefit still: some page loads will be slower, but you shouldn't get dramatic slowdowns that can happen with MyISAM.

Ok, thanks. I try with those in first post.

[Owdy]

CREATE TABLE `smf_log_floodcontrol` (
  `ip` char(16) NOT NULL default '',
  `log_time` int(10) unsigned NOT NULL default '0',
  `log_type` varchar( NOT NULL default 'post',
  PRIMARY KEY  (`ip`,`log_type`)
) ENGINE=MEMORY;

That table allready exist in my database.

Code Select Expand


CREATE TABLE `log_floodcontrol` (
  `ip` char(16) NOT NULL default '',
  `log_time` int(10) unsigned NOT NULL default '0',
  `log_type` varchar(8) NOT NULL default 'post',
  PRIMARY KEY  (`ip`,`log_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

So i just delete that one and create new? Or change engine?

[Arantor]

I don't believe you can change engine without dropping the table, but I'm not sure.

[Owdy]

I don't believe you can change engine without dropping the table, but I'm not sure.

Yes i dropped.

[Owdy]

Well, seems this makes my site run slower Load times are sometimes 1 second.

[Something like that]

Well, seems this makes my site run slower Load times are sometimes 1 second.

It's the innodb_flush_log_at_trx_commit=0 setting.

I would convert back for now.

[Owdy]

Ok, i restore backup.

edit: that tinytext convert should be okay, i do just that.

[aED]

Hi I don't have enough time to read all the pages but can I ask what is the new trick that was added in these topic. As I remember it was only 21 before now its 22. is it the Disabling of Eval?

[Arantor]

It might be.

There's even a handy mod for it now to make it a checkbox in your admin panel - Disable Template Eval

[aED]

It might be.

There's even a handy mod for it now to make it a checkbox in your admin panel - Disable Template Eval

Thanks

[Owdy]

Addition #2: Control your Expires Header - This is often done in server configurations but can also be done through .htaccess. Note that your provider needs to have mod expires on in order for this to function. This can drastically cut your forum's bandwidth needs.

# Turn it on
ExpiresActive On

# Set a default expiry time. One hour is fine, but a day or longer may be appropriate.
ExpiresDefault A3600

# Turn expiry off for dynamic content (or potentially dynamic content).
ExpiresByType application/x-httpd-php A0
ExpiresByType application/x-python-code A0
ExpiresByType text/html A0

<FilesMatch "\.(php|py|pyc|pyo)$">
  ExpiresActive Off
</FilesMatch>

How can i look if this on or off? Im shared host so i dont have acces to config files. And what that does actually do? Files are are downloaded less frecuently or something?

[Arantor]

Browsers receive a piece of information as to when a page 'expires', i.e. when the browser would need to go back and get it again if it has changed.

That page says, if you've seen a file that isn't HTML, PHP or Python (like an image), it won't change for the next hour. Meaning that for the next hour the browser shouldn't be requesting the images again - less page loads.

[Robin1989]

thanks for that some awesome tips in there

[chep]

Hello,

We have a forum of almost 400,000 posts. Just recently we started hitting an issue regarding long page load times. I ended up turning off a feature which has helped performance tremendously.

Admin -- > Features and OPtions --> Track daily statistics    ** Unchecked ***

Just thought I would mention how much it has helped us.

I have tried to join the Big Boards club but always get denied so I have to discover all these things by accident, hard research here or just trial and error.

[Aleksi "Lex" Kilpinen]

Hi chep, has it been long that you last asked for access? Just so you know - you are not too far away from the limit of posts that is normally required for the BB board access.

[Vekseid]

I should probably include that, many of us just like our stats, a lot >_>

[Something like that]

Just convert the log_* tables to InnoDB and the stats issue should go away, if you've done the other InnoDB optimizations.

[Vekseid]

Added a couple - not really as notable, but some may find them useful.

I'm thinking about making a server and security sections, but not sure if those should be their own topic given the size of the topic.

[Arantor]

Btw, 2.0 RC2 has the tinytext -> varchar conversion in, and for the disable template eval step, there's also a handy GUI item added from Disable Template Eval.

[Cal O'Shaw]

Hi,

If you don't mind the suggestion, when you add or adjust suggestions in the lead post, could you indicate the date the changes or additions are made.  It would make it a lot easier to locate the new tips.

Grazie mille!

Cal