Hossa,
I just made a little test on our test-database. I have an excel sheet
with about 2000 entries that should be updated with the same value. In a
first try I generated an SQL-Syntax for every entry like:
UPDATE xyz SET status=-6 WHERE id=xyz1 AND status>-1;
UPDATE xyz SET status=-6 WHERE id=xyz2 AND status>-1;
UPDATE xyz SET status=-6 WHERE id=... AND status>-1;
The execution of the ~2000 SQL-commands took about 5-10 seconds.
Then I tried the same with generating only one request using IN with the
twothousand entries like:
UPDATE xyz WHERE id IN (xyz1, xyz2, ....) AND status>-1;
and it took about 10 Minutes to execute. So it is nearly a hundred times
slower. Can this be verified? Is there anything that can be done about
that? Else I would need to have a few words with our programmers...
By the way the testsystem is a basic Suse 9.3 with a default postgres
installation 8.0.x
Thanks and
*greets*
Kai
