When you say optimize the tables, you're referring to a mysql function, correct? That's not done by the rebuiliding pieces with ubbthreads, correct?
I ran all the rebuild widgets except Rebuild Post Counts last night. They all ran fine except one. Rebuild Posts halted partway through with an error. The script exceeded the max execution time of 30 seconds in lib/html.inc.php.
I have 574,000+ posts, and it halted at 274,000+. I looked through the html.inc.php script, but I didn't see where the max execution time setting was. I need to know where that is so I can adjust it temporarily until I get the posts rebuilt.