Slow loading

[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]

We are also on a trial on a dedicated mysql server, so some of yesterday's performance issues were related to transferring the database.... all 1.6GB of it...while leaving the site up.

-RobA>

Total DB size is now 433 megabytes....lol...much more manageable

[bartmoss]

Total DB size is now 433 megabytes....lol...much more manageable

One word: CUTE.

That's nothing. :-)

[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!

[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.

[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.

[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