Search of catalogue by reader slow: solve by DB index on reader field(s)? [FIXED?]
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)?
Peter Dann
My solos: https://www.peterdannauthor.com/on-librivox/
Kirkus Reviews on my novel "1961": https://www.kirkusreviews.com/book-reviews/peter-dann/1961/
My solos: https://www.peterdannauthor.com/on-librivox/
Kirkus Reviews on my novel "1961": https://www.kirkusreviews.com/book-reviews/peter-dann/1961/
-
- LibriVox Admin Team
- Posts: 60725
- Joined: June 15th, 2008, 10:30 pm
- Location: Toronto, ON (but Minnesotan to age 32)
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.
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.
School fiction: David Blaize
Exploration: The First Four Voyages of Amerigo Vespucci
Serial novel: The Wandering Jew
Medieval England meets Civil War Americans: Centuries Apart
Humor: My Lady Nicotine
Exploration: The First Four Voyages of Amerigo Vespucci
Serial novel: The Wandering Jew
Medieval England meets Civil War Americans: Centuries Apart
Humor: My Lady Nicotine
-
- Posts: 7662
- Joined: August 20th, 2019, 8:25 pm
You'll be thrilled to see what the new update has done
Female Scripture Characters by William Jay (1769 - 1853) 97% 1 left! "The Penitent Sinner Part 2"
St. Augustine (Vol.6 Psalms 126-150) 96% 2 left!
PL pls: DPL DPL 21 43 27-28
St. Augustine (Vol.6 Psalms 126-150) 96% 2 left!
PL pls: DPL DPL 21 43 27-28
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!InTheDesert wrote: ↑December 7th, 2022, 8:22 pm You'll be thrilled to see what the new update has done
Peter
Peter Dann
My solos: https://www.peterdannauthor.com/on-librivox/
Kirkus Reviews on my novel "1961": https://www.kirkusreviews.com/book-reviews/peter-dann/1961/
My solos: https://www.peterdannauthor.com/on-librivox/
Kirkus Reviews on my novel "1961": https://www.kirkusreviews.com/book-reviews/peter-dann/1961/
-
- LibriVox Admin Team
- Posts: 60725
- Joined: June 15th, 2008, 10:30 pm
- Location: Toronto, ON (but Minnesotan to age 32)
Err, we didn't remember. Apparently this was one of the side benefits of updating our underlying software.
School fiction: David Blaize
Exploration: The First Four Voyages of Amerigo Vespucci
Serial novel: The Wandering Jew
Medieval England meets Civil War Americans: Centuries Apart
Humor: My Lady Nicotine
Exploration: The First Four Voyages of Amerigo Vespucci
Serial novel: The Wandering Jew
Medieval England meets Civil War Americans: Centuries Apart
Humor: My Lady Nicotine