github-mirrors/audiobookshelf
1
0
Fork 0
mirror of https://github.com/advplyr/audiobookshelf.git synced 2025-04-21 13:10:12 -04:00
Code Issues Projects Releases Packages Wiki Activity
audiobookshelf/test
History
Exact
mikiher 40504da4d7
Improve book library page query performance for author sort order (#4080) 
* Add migration to create authorNames* columns, in libraryItems including update triggers and indices

* Add authorNames columns and indices to LibraryItem model

* Add database triggers for updating author names in libraryItems (for new databases)

* Populate authorNames during book scanning

* Update book sorting to use new authorNames columns

* Add an index on podcastEpisodes.publishedAt

* Fix group_concat order by and update to sqlite 3.44.2

---------

Co-authored-by: advplyr <advplyr@protonmail.com>
2025-03-17 17:09:49 -05:00
..
server Improve book library page query performance for author sort order (#4080) 2025-03-17 17:09:49 -05:00