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

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@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"