Our biggest problem is the amount of comments we have. We have solved this by:
- creating a flattened version of the comment table and updating this table wih triggers (MySQL5) - writing new models and macros that replace the current macros that query the original comment table A blog page with many comments which would not load at all now loads in an acceptable time period. Why are the website ids not numerical? Cheers -- Want an e-mail address like mine? Get a free e-mail account today at www.mail.com!
