RE: newbie question - still: please help

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 13 Jan 2003 09:25:26 -0800
Message-ID: <F001.0052DD91.20030113092526@fatcity.com>

('binary' encoding is not supported, stored as-is)
>hi!
>
>a DBA inteds to speed up a script that is looping
>and
>sending hundred thousands of sequential update
>statements like:
>
>UPDATE ISIS_DOCAR SET STATUS = 2000 WHERE ID = n;
>
>he suggests copying the table to a file, change it
>and then
>load it into the DB again. i am strongly convinced
>that this
>is nonsense.
>
>what is the best way to go for a script like this,
>doing tons of
>updates? (except convincing him to swith to sell
>burgers)
>
>
>thx
>daniel

Would be curious to know your DBA's background. The most reasonable thing might be to size rollback segments as needed, and remove the loop (I guess your loop is here to enable you to commit regularly). The second best option would be (8.1.5 and over) to load PL/SQL arrays and do bulk updates (refer to the PL/SQL doc for bulk updates). Files have their use, but not this one.

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jan 13 2003 - 11:25:26 CST