Re: slow performance with sequences

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... Received on Tue Nov 09 2004 - 20:52:34 CST