Slow loading

[RobA]

PS: if it's mysql, what table types are you using? This may be too obvious, so my apologies in advance, but if you have MyISAM check carefully what they are used for, because MyISAM only does table locking. I have seen this myself in one situation, if you have say a session table that constantly gets updated, and it's myisam, you'll kill your site with that.

We are using InnoDB tables where possible to deal with this, though it is an overhead trade-off.

-Rob A>

[Robbie]

I just found something weird...the vb_cache table was 1.2 Gigabytes in size...just for the table...

So I cleared the cache and it dropped down to 300K...Home page load times should be significantly faster now, because there was a cache query that took 3 minutes to load.

Also, I think we're goign to look into keeping it MyIsam and going with a Sphinx solution...I've read good reviews...more info to come.

[bartmoss]

MyISAM is fine - unless you write to a busy table. If that happens, table locking will definitely kill you. In my experience, the InnoDB performance overhead is not an issue, but of course this will vary according to your specific situation. And also of course, InnoDB has other things to consider (need to be smart about the tablespaces, since they won't shrink automatically.)

Don't know Sphinx or what you'll use it for (sounds to me that it's useful for the site's search engine.)

[Robbie]

MyISAM is fine - unless you write to a busy table. If that happens, table locking will definitely kill you. In my experience, the InnoDB performance overhead is not an issue, but of course this will vary according to your specific situation. And also of course, InnoDB has other things to consider (need to be smart about the tablespaces, since they won't shrink automatically.)

Don't know Sphinx or what you'll use it for (sounds to me that it's useful for the site's search engine.)

From what I'm reading, yes it is...I need to make sure I can install it on our server. I think we can install whatever we want. How are the load times for you right now?

[ravells]

I don't know about anyone else but since Robbie posted about redoing the table the loading speed has really improved for me. Not sure if it's a coincidence and might slow down again, but I hope not!

[Robbie]

I don't know about anyone else but since Robbie posted about redoing the table the loading speed has really improved for me. Not sure if it's a coincidence and might slow down again, but I hope not!

There's no coincidence, only carefully calculated results from carefully executed procedures...lol.

[Thesslian]

Well, today the forum seems to be flying. Only takes three or four seconds for a page to load, as opposed to a minute or two that it was a few days ago. Being so new here I thought it was always slow.

[ravells]

lol, I think you've cracked it!!!!

[maxsdaddy]

"only carefully calculated results from carefully executed procedures" Great work from the SA's. Home page loaded in about three seconds, forums even less. Kudo's and thanks.

[Robbie]

Still working on further improvements...thanks for the feedback