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:
--
================================================== =================

Brian Peasland
dba (AT) remove_spam (DOT) 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"