Only if [complete rewrites](https://github.com/metabrainz/bookbrainz-utils/pull/40) (+16,272 −8,737) do not count 😜
monkey[m]
lucifer: Let me know when you have time to talk about the slow loading dashboard issue, I'm getting confused about what we're improving and where 😅
I'm testing on test.LB, but still seeing up to 40 seconds *initial* page load in some cases. Happy to help implement multi-stage loading (initial load returns whatever it can in minimal passes, then front-end does another API call to get the rest)
mthax joined the channel
I'm somewhat caught up after a quick chat with mayhem, will put down what I understood in a Gdoc
mthax has quit
lucifer[m]
[@monkey:chatbrainz.org](https://matrix.to/#/@monkey:chatbrainz.org) can you share where you see the 40s loading time?
mthax joined the channel
[@monkey:chatbrainz.org](https://matrix.to/#/@monkey:chatbrainz.org), [@mayhem:chatbrainz.org](https://matrix.to/#/@mayhem:chatbrainz.org) another option to speed up loading time, cache the latest 25 listens for every user in redis.
monkey[m]
Looking at the test.LB logs for user Kanau (fetch listens Kanau 39.95s (5 passes))
This is for their second or third pagte of listens (i.e. API calls, not initial load)
lucifer[m]
I see. So the fix shouldn't do multiple passes at all for initial load.
So it's working as expected.
monkey[m]
Let me check but I think the initial load was also slow
lucifer[m]
Subsequent loads will take longer as nothing has changed.
It shouldn't take more than 10-12s, which is not great but at least the page loads sort of.
We can shorted the one year search window to a few months and it would be faster.
<fettuccinae[m]> "Yes please" <- He agreed, made the change and pushed it to production. 😎
BobSwift[m]
<mayhem[m]> "https://playvinyltap.com..." <- Interesting that (at least today's puzzle for classic rock) seems to be based on the digital release which is the only one with that artist.
mayhem[m]
can of worms, cans of worms as far as they eye can see!
BobSwift[m]
Still pretty neat.
mayhem[m]
yeah. the goal is to do "wordle for music"
BobSwift[m]
I'm just bummed out because I would have gotten it on the first guess if they used the more common album artist. 😜
mayhem[m]
I think the author would appreciate hearing from you. want me to dm the email?
yvanzo: yes, it's a dependency of `recording_first_release_date`, so the script tries to build it in that case (and it's expected to be skipped if the table was previously built)