Speed up catalog search by reader

[twinkietoes-on]

A member wrote: "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)?"

Priority: 3 (Medium)

[ITD88]

Could someone who has a working version of the test database try profiling get_projects_by_reader on line 352 of application/models/Project_model.php

get_projects_by_author (Line 198) is the much faster version but I can't tell where the fundamental difference is.

[twinkietoes-on]

Apparently the software updates vastly improved this. We can probably close the issue and reopen it in the future if we discover it has slowed down again. (I'd close it, but I'm not sure which option to choose.)

[notartom]

Huh, I knew the new versions of MySQL and PHP were supposed to be faster, but I didn't expect it to be this... obvious?