[Erp5-dev] getMovementIndex

[Jean-Paul Smets]

Le mardi 24 Mai 2005 14:38, Yoshinori Okuji a écrit :
> On Tuesday 24 May 2005 13:17, Sebastien Robin wrote:
> > So I guess it might be very time consuming to maintain it, I think a
> > good optimization would be placed directly on
> > recursiveImmediateReindexObject, and it will benefits everywhere in
> > ERP5 (if it is not already done).
>
> Possibly. But it is not very easy to do that.
>
> The Right Thing to do is to use catalogObjectList of portal_catalog. But
> this method assumes that all objects are indexed from scratch, that is,
> no update or no conflict occurs. So it is necessary to modify
> catalogObjectList so that it can update objects (probably delete and
> insert), and can deal with uid duplications (like catalogObject). This
> will make it somewhat slower, so I don't like this very much.
>
> One way to avoid that performance loss is to add a parameter which says
> if SQLCatalog should make sanity checks. This is feasible, but this will
> still make it a bit slower, because we must add a dtml conditional into
> each Z SQL Method, like this:
>
> <dtml-if delete_before_insert>
> DELETE FROM catalog WHERE ...
> </dtml-if>
>
> YO

Baseline for me: unless you find a better and faster solution, please use / 
update / maintain getMovementIndex and related scripts. It is crucial for 
performance and usability of ERP5 in manufacturing related applications.

JPS.

-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 62 05 76 14
Nexedi: Consulting and Development of Libre / Open Source Software
http://www.nexedi.com
ERP5: Libre/ Open Source ERP Software for small and medium companies
http://www.erp5.org
Rentalinux: Desktop Linux Server
http://www.rentalinux.com