Hi all
Yes, there are significant issues with TOM's performance. They are two possible explanations:
1. Server side
2. Application (coding)
TOM was rewritten a couple of years ago to accommodate multiple leagues. However, while it did this superbly and added some great new functionality, it has not scaled up well as the seasons have passed. There are considerable issues with the use of views that is contributing to TOM going so slow at least in parts.
I am currently working on a complete rebuild of TOM that hopefully will address these issues and take away some of the major bottlenecks that we are experiencing. The core functionality is close to being ready for testing but the whole functionality will take time to replace. I'm having the same response time challenges with development
Once the new TOM is ready to go live, if we still have DB problems, I'll talk to Mark about moving the site to a new server.
I'll post a separate thread when the new version of TOM is ready for testing - some of the main pages should be ready for testing as early as this week.
Cheers
DD