Merged book code is creating long-running queries

bookwyrm-social / bookwyrm

Social reading and reviewing, decentralized with ActivityPub

http://joinbookwyrm.com/

Other

2.17k stars 255 forks source link

Merged book code is creating long-running queries #3379

Open mouse-reeve opened 3 weeks ago

mouse-reeve commented 3 weeks ago

Describe the bug I'm looking at queries that are taking too long on b.s, and I hit https://github.com/bookwyrm-social/bookwyrm/pull/3299/files#diff-d0c61e914db77e19e340b5cf217a89c2032d6288d40deb444d0923a17f52f8d0R51

Just to keep us out of OOM errors, I removed the Q(absorbed__deleted_id=book_id) filter and have had much better results. I wouldn't have expected that to much such a big difference! But here we are.

mouse-reeve commented 3 weeks ago

(cc @Minnozz, but no pressure to take this on)