Re: slow performance with sequences

john b wrote:

> sequences that I'm having. In essence when I do a mass insert
> (525,000 records - it's a very narrow table) into a table without a
> sequence with a trigger the insert happens in two seconds; when I do
> the same with the trigger on and sequence used it takes 1 minute and
6
> seconds. The table does not have any indexes. I cached the sequence

Lose the trigger and use the tmp_seq.nextval directly in populating the table.

Like Mark said: there are a coupla problems with referencing the nextval of a sequence, one of them is that you can't use it directly inside PL/SQL without the silly DUAL table. Received on Tue Nov 09 2004 - 05:29:32 CST