[Zope] Faster ZCatalog Searches (better? Optimized?)

Dieter Maurer dieter@handshake.de
Mon, 29 Apr 2002 22:31:07 +0200


Toby Dickenson writes:
 > On Fri, 26 Apr 2002 14:26:39 -0400, BZ <bz@bwanazulia.com> wrote:
 > 
 > >ZUBB:
 > ><dtml-in "searchResults(in_reply_to=[''])" size=batch_size reverse 
 > >sort=id start=query_start>
 > 
 > You are are getting dtml-in to do the sorting, not the catalog. The
 > difference may be very small, or very large
 > 
 > Try this (untested) code as a perfomance test
 > 
 > <dtml-in "searchResults(in_reply_to=[''],sort_on='id')"
 > size=batch_size 
 > start=query_start>
 > 
 > That should be faster, but reverses the sort order. In not sure if
 > putting the 'reverse' dtml-in tag back in will incur a performance
 > penalty.
You can add "sort_order='reverse'" to the "searchResults".

Using the "reverse" attribute of "dtml-in" would probably make it
slower because the lazyness of the search result is removed.



Dieter