Search of catalogue by reader slow: solve by DB index on reader field(s)? [FIXED?]

TheBanjo · Post by **TheBanjo** » November 3rd, 2021, 5:52 pm

I've noticed that any search of the Librivox catalogue by reader is very, very slow. I'm wondering if the speed of this search could be improved by an expedient as simple to implement as creating a database level index on the relevant reader field(s)?

Post by **TriciaG** » November 3rd, 2021, 6:08 pm

I read this to my software developer husband, who has done some improvements on the LV code in the past.

Me: "Is it not that simple?"

Him: "I don't know. It could be. There may be other reasons why it's really slow. At least the reader and author selection boxes work now."

We'll add it to the list of things for developers to look at.

InTheDesert · Post by **InTheDesert** » December 7th, 2022, 8:22 pm

You'll be thrilled to see what the new update has done

TheBanjo · Post by **TheBanjo** » December 7th, 2022, 11:44 pm

InTheDesert wrote: ↑December 7th, 2022, 8:22 pm You'll be thrilled to see what the new update has done

Certainly am! That's a fantastic improvement. Almost (ahem...) what I would expect of a reasonably well-tuned database, actually. Very good to see, no doubt about that. Thank you for remembering my old request about this!
Peter

Post by **TriciaG** » December 8th, 2022, 6:27 am

Err, we didn't remember. Apparently this was one of the side benefits of updating our underlying software.