@nichwall commented on GitHub (Nov 1, 2024):
Sounds like a plan. Are you seeing something like "Ran query in X Ms" in the logs? You will need to switch the log level to Debug in the server…
@oddstr13 commented on GitHub (Nov 1, 2024):
Yep, the appropriate logs are active.
I wouldn't expect relatively simple queries such as this one to take quite this long, but I suppose my NAS is…
@alxgarci commented on GitHub (Aug 6, 2024):
For others having the same issue: Since it's hard for me to understand all the code and queries, i opted to comment every line inside those methods…
@github-actions[bot] commented on GitHub (Oct 27, 2024):
Fixed in v2.16.0.
@advplyr commented on GitHub (Oct 28, 2024):
If you update to v2.16.0 I'm curious how much the performance improves
@alxgarci commented on GitHub (Oct 28, 2024):
Sry just gave up on having 100k+ books and started a new library with just 2k, so can't monitor the performance for now. But thanks for the fix! Will…
@oddstr13 commented on GitHub (Nov 1, 2024):
If you update to v2.16.0 I'm curious how much the performance improves
I can't say I see a noticeable improvement, but the time is still beyond…
@nichwall commented on GitHub (Nov 1, 2024):
Would you be willing to share your database? I'm curious why the "Continue Listening/Reading" query is 30 seconds long. That seems excessive,…
@oddstr13 commented on GitHub (Nov 1, 2024):
@nichwall I'd rather not dump the whole database, but I can run some queries for you, if you give me some pointers?
@nichwall commented on GitHub (Nov 1, 2024):
I'd rather not dump the whole database, but I can run some queries for you, if you give me some pointers?
If you set the environment variable…
@oddstr13 commented on GitHub (Nov 1, 2024):
I've enabled query logging. Not seeing the slowness right now, but it tends to only happen the first time loading the app (after a longer pause). The…
@Tspm1eca commented on GitHub (Aug 5, 2024):
me too raspberry pi OS 3B+ 64bit
@mikiher commented on GitHub (Aug 5, 2024):
This is a duplicate of #3231. Please see discussion there.
@nichwall commented on GitHub (Aug 5, 2024):
Duplicate of https://github.com/advplyr/audiobookshelf/issues/3231
@nichwall commented on GitHub (Aug 6, 2024):
I'm not very familiar with SQL or database queries, but from initial research, it looks like the slowdown for "Recent Series" and "Newest Authors" are…
@nichwall commented on GitHub (Aug 6, 2024):
Well, I just tried that change locally, and turns out the HasMany association does not exist for this query, so separate: true does not work. I…