Ticket #1865 (new defect)

Opened 4 years ago

query builder instantiates too many objects when limits are set

Reported by: flack Assigned to: bergie
Priority: major Milestone: 8.09.10 Ragnaroek
Component: MidCOM core Version: 8.09 Ragnaroek
Keywords: Cc:


The reason is that limit/offset are applied only after the objects are instantiated by execute_and_check_privileges in a foreach loop. Ideally, the loop should stop when the limit is reached, especially since instantiations of DBA objects are expensive because of the privilege checks and all that.