Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way for updating EVERY row in a large database?
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
![]() |
![]() |