views.otu_search() performs a query for the entire result set and caches that.
That large set of values is then sliced down to a single page's worth in Python
This makes retrieving the first page worth of results really slow, unless it's cached.
Given that the query is sorted (check this), it should be possible to slice the unevaluated query (i.e. use select … limit … offset …)
views.otu_search()
performs a query for the entire result set and caches that. That large set of values is then sliced down to a single page's worth in PythonThis makes retrieving the first page worth of results really slow, unless it's cached.
Given that the query is sorted (check this), it should be possible to slice the unevaluated query (i.e. use
select … limit … offset …
)