Item10432: SEARCH w/paging terribly slow
Priority: Urgent
Current State: Closed
Released In: n/a
Target Release: n/a
The following
SEARCH executes in 4.8s bruteforce, 28s mongo on
TaxonProfile.Definitions
%SEARCH{
"1"
type="query"
nonoise="on"
format=""
footer="$ntopics"
}%
Maybe there's a better way to get the total number of topics out of a query
--
PaulHarvey - 02 Mar 2011
Whoops, corrected (and tested, confirmed behaviour with) the search expression.
--
PaulHarvey - 02 Mar 2011
In terms of immediate needs, I can make-do with a perl method of getting a hit count (ignoring ACLs)
--
PaulHarvey - 03 Mar 2011
If it's not too much effort, until we fix ACL perf. properly, would be really awesome if we could some sort of "demo mode" hack that either gives us a fast total-topic count from the resultset from perl, or even better, makes this nice and fast:
%SEARCH{
"form.name='Lauries.GlossaryForm'"
type="query"
web="Lauries/GlossaryData"
pager="on"
}%
--
PaulHarvey - 19 Mar 2011
this was the confluence of 2 Search bugs that 'worked fine' on core, but are even more inefficient when running listeners and custom Meta/InfoCaches
--
SvenDowideit - 23 Mar 2011
Wow, that was a huge speed-up! Down from 30s to ~1s per page. Nice work
--
PaulHarvey - 23 Mar 2011
lets call it closed and move on
--
SvenDowideit - 24 Mar 2011