Re: import of LONG columns

I've had a similar problem with one of my regular imports. I set BUFFER to a larger value. I also increased the size of my buffer cache. That seemed to help me.

HTH,
Brian

Harry Boswell wrote:
>
> I've been working for a while now to improve the import time of one of our
> schemas. One table takes up most of the import time, and it has a LONG
> column in it. Most of the objects are fairly small, but about 40 are much
> bigger - the largest is about 34.8 MB, and there are a few others that are
> larger than 15 MB. Would increasing the BUFFER parameter size to a very
> large value help this? (I'm thinking on the order of 35000000). Currently
> this import is taking about 6 hours, and the one table makes up about 5 1/2
> hours of that.
>
> Thanks,
> Harry Boswell

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"