Danbooru

Post search slowdown for 3+ tags (2-6)

Posted under General

I've been experiencing wierd slowdowns, failboorus, and such for the last day or so too. Strangely though I wasn't seeing it when everyone else was complaining a week or so ago.

I haven't noticed any particularly different slowdown for 3+ tag searches though. Perhaps 2 tag searches are running faster for you since they are more likely to be cached (in part because they are the searches normal members run).

I couldn't tell you why the page rendering is taking so long but a quick search confirms.

0 Total: 0.043486s; DB: 1.9e-05s; Page: 0.043512s; Created 22:16
1 Total: 0.067489s; DB: 3.0e-05s; Page: 0.067492s; Created 22:16
2 Total: 0.37853s; DB: 2.2e-05s; Page: 0.378531s; Created 22:16
3 Total: 6.089525s; DB: 3.6e-05s; Page: 6.089511s; Created 22:16

Log said:
I couldn't tell you why the page rendering is taking so long but a quick search confirms.

The bottleneck is in calculating the related tags for the sidebar. If it takes longer that 6 seconds to calculate then there's an SQL timeout and the tag sidebar won't be displayed.

evazion said:
The bottleneck is in calculating the related tags for the sidebar. If it takes longer that 6 seconds to calculate then there's an SQL timeout and the tag sidebar won't be displayed.

Could it be switched around to show the Wiki by default instead of the related tags, and if people want to see related tags, then it calculates the related tags when they click "Tags"?

evazion said:
The bottleneck is in calculating the related tags for the sidebar. If it takes longer that 6 seconds to calculate then there's an SQL timeout and the tag sidebar won't be displayed.

Did something change recently with that, or is this just part of a general performance hit Danbooru's been taking lately?

If that's the hangup, what about having the tag list load separately, after the rest of the page has already been displayed?

jjj14 said: Could it be switched around to show the Wiki by default instead of the related tags, and if people want to see related tags, then it calculates the related tags when they click "Tags"?

I really, really wouldn't want to have to do this to see the related tags every time, personally. I already had to install the script to put the wiki entry back on the initial results page.

1