Text only | Text with Images

Boyah Forums

General => The Lobby => Topic started by: don't let's on June 24, 2018, 01:54:57 PM

Title: When the indexes load so fast but the threads so slow
Post by: don't let's on June 24, 2018, 01:54:57 PM
Title: Re: When the indexes load so fast but the threads so slow
Post by: bluaki on June 24, 2018, 02:34:01 PM
Different database tables.

I don't know exactly how SMF stores its databases, but querying the index basically only requires the list of threads and the ranks of each user. Loading the threads requires that plus the posts table (which is huge thanks to all our chat threads) and all the other user info like quota calculation and last.fm integration
Title: Re: When the indexes load so fast but the threads so slow
Post by: Kalahari Inkantation on July 01, 2018, 06:29:05 PM
entirely snorkel's fault
Title: Re: When the indexes load so fast but the threads so slow
Post by: C.Mongler on July 02, 2018, 12:16:45 PM
Quote from: Magyarorszag on July 01, 2018, 06:29:05 PM
entirely snorkel's fault
Text only | Text with Images