Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best way for updating EVERY row in a large database?

Re: Best way for updating EVERY row in a large database?

From: Konstantin Kivi <konst_at_sirena.rinet.ru>
Date: Mon, 27 Apr 1998 04:40:56 GMT
Message-ID: <Es22C8.199.0.debian@sirena.rinet.ru>


Henk de Wilde <dewildeh_at_xs4all.nl> wrote:
> On Thu, 23 Apr 1998 09:22:13 -0400, "Jim Morgan" <jimmorgan_at_csi.com>
> wrote:

> Have you considered updating a _range_ in one statement. Say you have
> a primary key ranging from zero to 4,000,000 more or less evenly
> distributed in that range, you could then update key 0 to 400,000,
> commit, key 400,001 to 800,000 etc... You can make the ranges as big
> as is convenient for you and you'd miss a lot of the overhead
> associated with the switch from SQL to PL/SQL .

Strange, but nobody noticed that sometimes one must run his program several times or the program can crash - so he(she) must to remember the point where it fails.

--
Sincerely Yours, Konstantin Kivi, Russia, konst_at_sirena.rinet.ru

    aka <k-kivi_at_usa.net>, 2:5020/457.24_at_fidonet.org           Received on Sun Apr 26 1998 - 23:40:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US