Re: Execute 650 mb sql script
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 11 Apr 2005 17:25:12 +0200
Message-ID: <d3e4m8$qs3$1_at_news5.zwoll1.ov.home.nl>
>
>
>
>
>
>
>
> Could this suggestion (based as you point out on minimum info) be
> valid in *_some_* circumstances?
>
>
> Paul...
>
Date: Mon, 11 Apr 2005 17:25:12 +0200
Message-ID: <d3e4m8$qs3$1_at_news5.zwoll1.ov.home.nl>
Paul wrote:
> DA Morgan <damorgan_at_x.washington.edu> wrote:
>
>
>>Paul wrote:
>
>
>>COMMIT regularly
>
>
>>As IANAL_VISTA indicates ... a really bad idea.
>
>
>
> Could this suggestion (based as you point out on minimum info) be
> valid in *_some_* circumstances?
>
>
> Paul...
>
[Quoted] [Quoted] Yes. Break up the 650MB file in small chunks.
And and insert into table(...) values (...); will succeed, as long
as that piece of code remains smaller than 32kB
(or larger - latest version, which is absent again...)
<rant>
Really appreciate the feedback, bhawin13.
BTW, who named you that?
</rant>
-- Regards, Frank van BortelReceived on Mon Apr 11 2005 - 17:25:12 CEST