/a/ - adventures
you guys wouldn't believe how much faster we got the threads to load
2024-07-19 10:10:03
No.5
you guys wouldn't believe how much faster we got the threads to load
Current speed:
- Threads loaded in 5.50 ms
Prev speed:
- Threads loaded in 2312.41 ms
That's an improvement of 2306.91 ms, or 99.76%...
2024-07-19 10:15:15
No.6
redesigned the entire database schema into an adjacency list model and rewrote how posts/threads are retrieved
how it works is so much simpler... i shouldve done this from the start but i just love to make my life harder
2024-07-19 10:31:37
No.7
me = retarded
main bottleneck was the cache (which was entirely useless) and also how i was looping through threads and making multiple fetch requests per page load, looping through threads + fetching separately per reply was like n + (n * replies) queries extra i that didn’t need to be doing
retardmaxxing tbh
2024-07-19 19:06:10
No.14
insane speedup
2024-07-20 00:00:30
No.212
ty king
New Reply