Re: newbie question - still: please help

Even with this little bit of information, it's obvious your DBA is on the right track.

Any script that loops and executes 'hundred thousands of sequential update statements' is total nonsense.

This will bring most any database to it's knees in a hurry.

Oh yes, I've had developers pull this one on me. How about a 10gig text file of INSERT statements?

Please supply more info, but from what you have here, I would say you should start listening to your DBA.

Jared

On Monday 13 January 2003 08:14, Daniel Wisser wrote:
> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).