[Tickets #11064] Turba Browse is very inefficient

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11064
------------------------------------------------------------------------------
  Ticket             | 11064
  Created By         | Michael Slusarz <slusarz at horde.org>
  Summary            | Turba Browse is very inefficient
  Queue              | Turba
  Version            | Git master
  Type               | Enhancement
  State              | New
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Michael Slusarz <slusarz at horde.org> (2012-03-09 13:01) wrote:

Browsing in Turba (at least via SQL driver) will query ALL contacts on  
every page, regardless if you are filtering - for example, by a letter  
when using the alphabet pager.  It is the View code that is doing the  
filtering.  This is incorrect behavior - the query should be filtered  
at the DB level instead - it reduces overhead and SQL is precisely  
designed for this kind of filtering, so it is the proper tool for the  
job.