As you are all aware, there is a problem with posting. I do know the database table where all posts are stored has been having issues for years just by looking at all the double/triple postings over the years. It's just more prevalent now that were are getting more traffic to the site than it has had in years. I have investigated into the issue debugging on the site here and 2 database tables show up to be the issues and you guessed it, the biggest culprit is the table where posts are stored for the forums. It's completely choking the SQL server to the point where it times out or a script is set up to kill processes if they run over 45 seconds. I'm sure that table is huge and it has some big performance issues because of it, at least that is my guess at this point. There can be other contributing factors causing these tables to take a long time inserting and pulling records as well.
Unfortunately ZAM is busy right now working on their featured sites and they can't spare developer resources for our site. However I was recently brought on as a consultant for ZAM and have looked over what I have access to right now. Once I get all the proper access I need I will be able to properly look through logs, monitor server performance and see what all is involved in the problem.
I have some theories as to what is contributing.
1. Large SQL tables performing badly.
2. Poorly designed pages with large SQL queries.
3. Heavy traffic on these poorly designed pages.
I just wanted to let ya guys know that we are aware of the issue and no one wants to get this fixed more than me. I work on the site quite a bit almost every day and it gets real old timing out, getting errors, double/triple posting. In posting this, it timed out on me and the entire site went unresponsive, ya it's quite annoying.
Edited, Aug 1st 2017 12:09am by Gidono
Volunteer Allakhazam Developer and Admin
For real time update information on Allakhazam, follow me on Twitter! https://twitter.com/gidono
To make a Donation directly to me. https://paypal.me/Gidono
So far I have received 0 donations.