Fork / Pull Request Created (Development)
Hi Micha / Auge / friday-admin,
I'm now done with my code changes and extensive testing of the SQL performance modifications. Since it does not appear that I can write to My-Little-Forum, I created a fork and pull request for the changes. 4 total includes files changed: entry, index, main, and thread.
Performance Note: In all instances tested, page load time went from 10-15 seconds in base 20240308.1 down to sub 1 second with these modifications. I do see about a 40% increase in page load time over 2.4.24 (from 500ms to 800ms avg), but page load is still acceptably under 1 second, even within our forum of 500,000 posts / 40,000 threads. If these modifications work for you, it should hopefully eliminate a need to further customize SQL queries based on forum spam settings.
Joe