G�rard wrote: > > Is famille indexed? > No, but there are only 30 Familles (Categories) May I suggest indexing them by whatever matches the query in RechercheFamille?
Since there are so few, if you really have to open them at all, you should keep the orefs in an array and leave them open until you are finished. > > Yes, can you avoid opening that one object? > I open the object to be able to do : > Set product.LaFamille=famille I'm pretty sure that's not a good enough reason. > LaFamille is an embbeded object in class product (Property LaFamille As > Catalogue.Famille) That sounds like just a pointer. Is Catalogue.Famille persistent? > > > It seems that this problem could be from > > > the performance of the insert after a lot of other inserts. > > True, but this problem wouldn't occur if you weren't opening the objects. > Yes but to put the product in the right category I use > Set product.LaFamille=famille Do you understand that famille is an oref and just gets turned back into an OID when you save?
