You are here: Foswiki>Tasks Web>Extension>MongoDBPlugin>Item10430 (09 Mar 2011, SvenDowideit)Edit Attach

Item10430: Need a performant filter-as-you-type query

pencil
Priority: Enhancement
Current State: Closed
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: MongoDBPlugin
Branches:
Reported By: PaulHarvey
Waiting For:
Last Change By: SvenDowideit
Currently we use 
%SEARCH{"lc(SomeField)=~lc('SomeValue')" type="query"}%

This is very slow on MongoDB atm; TaxonProfile.Definitions web takes ~13s to do a query, whereas bruteforce is ~5-7s

Happy to re-write the query to avoid lc() function, maybe 
%SEARCH{"SomeField=~'(?i:SomeValue)'" type="query"}%
maybe this even already works

-- PaulHarvey - 02 Mar 2011

parser optimisation added to the mongodb hoister - hope that gives a significant speedup

-- SvenDowideit - 02 Mar 2011

Thankyou, that does help. I think this task has run its course; main bottleneck is now Item10461

-- PaulHarvey - 09 Mar 2011
 

ItemTemplate edit

Summary Need a performant filter-as-you-type query
ReportedBy PaulHarvey
Codebase trunk
SVN Range
AppliesTo Extension
Component MongoDBPlugin
Priority Enhancement
CurrentState Closed
WaitingFor
Checkins MongoDBPlugin:56d836311ed7
TargetRelease n/a
ReleasedIn n/a
Edit  | Attach | Print version | History: r6 < r5 < r4 < r3 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r6 - 09 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