[Tickets #11064] Re: 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
  Updated By         | Ralf Lang (B1 Systems GmbH) <lang at b1-systems.de>
  Summary            | Turba Browse is very inefficient
  Queue              | Turba
  Version            | Git master
  Type               | Enhancement
  State              | New
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Ralf Lang (B1 Systems GmbH) <lang at b1-systems.de> (2012-03-09 21:09) 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.

Driver->search should support criteria like limit(n) and %like% or  
startwith('a')
This probably applies to more backends.