| Title | Meta: Late Christmas Present | |
| Date | Wednesday January 09 2019, @12:59PM | |
| Author | ||
| Topic | ||
| from the better-late-than-never dept. | ||
While shutting down terminal windows to the SN servers this morning, one of them had the create table syntax for the comments table still on screen. I gave it a read through just because it was there and noticed that there wasn't an index for the opid (top level comment id for speeding up entire thread pulling) column. So I got some before numbers, added one, and ran some After tests. Heavily commented stories show a 50-150% pages-per-second speed increase in threaded views. Low hanging fruit FTW.
| Links |
printed from SoylentNews, Meta: Late Christmas Present on 2024-04-16 05:39:55