Postby JQW » 12 Aug 2010, 17:22
I've isolated the remaining problems down to two issues:
The period site purges. When searching a forum for valid posts the software currently fetches a list of suspected posts, and then double checks them to make sure they're valid before deletion. It's the double checking that's causing some of the problems, as it needs to fetch a lot of info to be double-checked.
The second is when users try to view another user's post history. This causes another query which fetches a lot of data, whilst also attempting to count and order this data. Again this puts a heck of a load on the server.
I can get around the first by manually running a purge using other methods, and then turning on the auto purge, which I've just done. The second requires the relevant code to be seriously amended to prevent the needless counting, or disabled completely. I'll look into what I can do.
The trouble with the world is that the stupid are cocksure and the intelligent are full of doubt. - Bertrand Russell