Jerome Raupach <[EMAIL PROTECTED]> writes:
> I have a big problem of performance, please help me.
You could code the update so it only evaluates the view once,
rather than twice per table2 row as you now have it:
UPDATE table2 SET
nb=table2.nb+view1.nb,
time=table2.time+view1.tim
I have a big problem of performance, please help me.
it is my work :
first : COPY table1 FROM 'file'-> 43s,
INSERT INTO table2 -> 34s,
UPDATE table2 -> 1mn 29s ( =2m 46s : OK)
second : COPY table1 FROM 'same file' -> 1m 10s,
INSERT
