- Location
- Westchester, N.Y
Getting harder and harder and slower at times. It's been months that you have bugs in your server. Nice site but losing interest in visiting when it's so slow. Sorry for neg Post
Getting harder and harder and slower at times. It's been months that you have bugs in your server. Nice site but losing interest in visiting when it's so slow. Sorry for neg Post
I know - right? Im about to start trolling Reef Central
database is the bottleneck to performance here. I am suggesting to reindex your MySQL DB and archive old posts. The amount of data and concurrent users add up quickly.
Same experience as cmantis. I can't even go to the F/S section. Keeps redirecting to kalk dosing thread on chemistry whenever I click the F/S.
This has been going for 2 days now.
From my experience it is data related from the symptoms we've been seeing.
When the site fetches incorrect pages this is a problem with the primary key indexing.
OPTIMIZER_MODE: ALL_ROWS is good for Batch processing, FIRST_ROWS is good for Interactive(OLTP)
OPTIMIZER_INDEX_COST_ADJ : 100 means full table scan, 1-10 means use Index.
Create Index table space for Indexes( separate data and Index)
Separate the current data and historical data for large tables.
It's tough running a high traffic forum.. best of luck on a resolution!
Have you tried restarting your browser yet?