Item10432: SEARCH w/paging terribly slow

pencil
Priority: Urgent
Current State: Closed
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: MongoDBPlugin
Branches:
Reported By: PaulHarvey
Waiting For: Main.SvenDowideit
Last Change By: SvenDowideit
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 smile

-- PaulHarvey - 23 Mar 2011

lets call it closed and move on smile

-- SvenDowideit - 24 Mar 2011

 
Topic revision: r9 - 24 Mar 2011, SvenDowideit
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy