Re: Speeding up import

Brian Dick <bdick_at_home.com> wrote:
> An import of 12 million rows into about a dozen tables in our 8.1.6 database
> takes about 6 hours. The export only took 12 minutes. What can we do to
> speed up the import?

Hi

The most time consuming part of import in case of my db is

1. Creating indexes
2. Creating constraints

I use this way.
To import just data and nothing else.
Then I rewrite commands for creating indexes to run in parallel and two ore more scripts together. Then I create constraints with novalidate clause.

        Starous Received on Fri Mar 16 2001 - 04:27:16 CST