Item12500: %QUERY's getField is highly inefficient
Priority: Urgent
Current State: Confirmed
Released In: 1.2.0
Target Release: minor
Applies To: Extension
Component: FoswikiStore
Branches: trunk
... when fetching a property of a non-topic revision.
Example:
%QUERY{"'%WEB%.%TOPIC%'/versions[1].info.author"}%
This checks out every single revision down to rev 1 resulting in a lot of sysCommands calling rcs. Instead it should just fetch the given revision.
Related:
Item11983: prevent excessive calls into the revision system
Here's the problem in all of its beauty when viewing a topic with 139 revisions:
--
MichaelDaum - 16 May 2013
This is a known problem with the way old versions are queried. It may be possible to implement some sort of hoisting optimisation in the query engine. Anyone is welcome to try#.
--
CrawfordCurrie - 20 May 2013