Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: slow performance with sequences
wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0411091852.75e6107b_at_posting.google.com>...
> jbdba01_at_hotmail.com (john b) wrote in message news:<d4e20c83.0411090925.305b8065_at_posting.google.com>...
>
> > So I droppped from 1 minute to 15 seconds, and then after I cached a
> > big ol' bucket of sequences (100000) I got it down to 3 seconds;
> > better, but what a pain - this means I really have to ensure that the
> > insert for that big table are different than all the smaller tables.
> > I was hoping to avoid that as the developers are primarily sql server
> > literate and understand/like/work with SQL Server identities. Oh
> > well...
>
> Well you know, you want the best, you need the best! :)
> Seriously: I hope Oracle is hearing you...
Resolved the issue by issueing natural keys and dropped the sequence altogether. This is the only table that will be this way as it is a high volume load table.
JB Received on Wed Nov 10 2004 - 05:58:20 CST