Multiple sort keys for ZCatalog searching (was: RE: [Zope] Ha rdware for Zope + ZEO)

[sean.upton@uniontrib.com]

+1

I have an application that needs a performance boost that this might offer
over my existing workaround.  In my application, I have online classified ad
listings for real-estate listings(perhaps thousands in any given category),
and need to sort on a geographic area, and then on a title.  My current
strategy is to do my own smart-but-bloated multi-pass sort of the entire
result set for each request, then display batches using that result set,
which uses more RAM and CPU than I would ideally like.

Sean

-----Original Message-----
From: Dieter Maurer [mailto:dieter@handshake.de]
Sent: Friday, March 28, 2003 3:27 PM
To: Wankyu Choi
Cc: sean.upton@uniontrib.com; tdickenson@geminidataloggers.com;
mvalente@ruido-visual.pt; zope@zope.org
Subject: Multiple sort keys for ZCatalog searching (was: RE: [Zope]
Hardware for Zope + ZEO)


Wankyu Choi wrote at 2003-3-27 05:24 +0900:
 > ....
 > I need two sort keys: one to sort the threads (parents) and the
 > other to sort their replies (childs). ZCatalog supports a single sort
index,

I have code to extend ZCatalog's sorting capability to arbitrary many
sort keys.

Maybe, we want something like this in the Zope core?


Dieter