I thought the board was running better today, and it was, but when I logged in to post in this thread I got the dreaded, "Fatal error: Maximum execution time of 30 seconds exceeded in D:\WebRoots\dawgtalkers.net v2\libs\mysqli.inc.php on line 208" again. I usually don't log in when I come here, but when I do I get that message more frequently than when I don't.
It's hard to believe that this can't be fixed. It's been like this for several years now, especially when the board is busy.
I actually have a log of long-running/slow queries that I just looked at today; there are only a few that seem to really slow things down, but I haven't had an opportunity yet to dive into how best to improve them.
Part of me things that just a configuration change for MySQL should get it done, but I think there are schema changes needed. I suspect that something as simple as adding an index would make a huge difference, but I need to inspect the tables in the query first to know.
I did have MySQL optimize all tables today (if the site was returning a 500 error for you at any point, that was it, lol) and that should have improved things a little. To date, however, it was always a crapshoot as to whether or not the performance issues were the site or actually phantom errors from things external to the site.
