thanks a lot 4 your replies.
/*i followed the way dick and mark suggested.*/
daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
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
Daniel,
Your gut reaction is right on-target. It is always a struggle to keep
certain folks from killing the entire village while trying to cure a single
case of the sniffles. What's worse is that such folks are usually quite
bright and talented. After, very few mediocre folks can either cure t
>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
>
Daniel - Can you explain the two alternatives in a little more detail,
especially the difference between the two. What types of systems are
involved (Unix, Windows)? Thanks.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 13, 2003 1