Re: Tuning database for inserts

Hi,
one thing that influences the speed in inserts tremendously is the existence of indexes. Do not insert such amounts of data into tables with indexes, especially unique. It pays to drop the indexes, do the insert and recreate the indexes afterwords. Even if you are not sure of the uniqueness of keys in the input files, the work spent in finding and eliminating duplicates prior to creating the indexes is much smaller than the time spent on inserts with indexes.
Well, my experience is on smaller systems with Windows NT, so I can speak only for this.

Regards,
Pavel

Ian <Ian.Lewis_at_nospamsynectics-solutions.com> wrote in article <01bd27f7$f3a368e0$67675cc3_at_pccomms_ian>...
> We have an Oracle 7.3. database on an NT4Server.
>
> To build the database we are inserting data into tables from ascii files,
> and from imports from other Oracle databases.
>
> What would you recommend the best set up of the Database to be - the
> imports are approx 1.7 million rows max?
>
> - should we have a lot of small sized Rollback segments, (how many?,What
> size?)
>
> what other initialisation parameters would you recommend setting, that
> would improve performance speed when inserting the data.
>
>
> Thanks in advance
>
> Ian
>
  Received on Fri Jan 23 1998 - 00:00:00 CST