[Erp5-dev] some missing methods

[Sebastien Robin]

Le mardi 19 Avril 2005 19:12, Yoshinori Okuji a écrit :
> These Z SQL Methods are missing:
>
> - z_catalog_delivery_list
>
> - z_catalog_predicate_list
>
> - z_catalog_predicate_category_list

I have added the predicate table and predicate_category table. So I can 
fix.

I have a question, may be it is a bit stupid, but I would like to 
undestand why we need to create a z_xxx_list zsql method.

If I'm correct, I guess we use z_xxx_list in order to catalog a list of 
objects by the same time, so instead of calling mysql 100 of times, we 
will call it only 1 time.

So we may have only one query like this (case 1):
insert into catalog values 
  (a,b,c),
  (d,e,f),
  (g,h,i);

Here is my question : isn't it possible to only use the z_xxx method 
(without list), take the output of the method on each object without 
calling mysql, then join the output and then call mysql ? we should have 
something like this (case 2):
insert into catalog values (a,b,c);
insert into catalog values (d,e,f);
insert into catalog values (g,h,i);

In both cases, we call mysql only one time, and in the second case we 
don't have to write a z_xxx_list zsql method.

Isn't it possible to do the second case ? Is there an import perfomance 
difference ?

I guess it is important that everyone understand why use use z_xxx_list 
zsql method, so any explanation will be welcome.


  Seb.


>
> Because of this bug, the hot reindexing does not work correctly.
>
> YO

-- 
Sebastien Robin, Nexedi Technical Director
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com
ERP5: Free / Open Source ERP Software for small and medium companies
http://www.erp5.org
Storever: OpenBrick, WiFi infrastructure, notebooks and servers
http://www.storever.com