Re: [PERFORM] Initial insert

Hi, On 22.1.2015 17:46, Laurent Cathala wrote: > Hi, > I'm trying to create datas on an initial import and i'm encountering a > performance issue. > I've 2 tables, my process create a record in each table and execute a > sum with join on this 2 tables. (and other requests but there are very fast)

Re: [PERFORM] Initial insert

Hello, I forgot to mention my version : 9.2 thanks, *Laurent CATHALA*Architecte l...@sylob.com *7 rue Marcel Dassault - Z.A. La Mouline - 81990 Cambon d'Albi - FRANCETel : 05 63 53 08 18 - Fax : 05 63 53 07 42 - www.sylob.com Support : 05 63 53 78 35 - supp...@sylob.c

[PERFORM] Initial insert

Hi, I'm trying to create datas on an initial import and i'm encountering a performance issue. I've 2 tables, my process create a record in each table and execute a sum with join on this 2 tables. (and other requests but there are very fast) My 2 tables are empty before the import. My count query