Subject Re: [firebird-support] Re: MAX(ID) Performance
Author Dimitry Sibiryakov
> I'm using generators in firebird trigered by on insert event triger in database, but when I need to know ne ID value on client for a new 100 records and when I have about 50 clients I cant fetch new generator value because of performance, so I fetch last ID (or actual generator value) and internal generate new values and than set up new value to generator (it mean that I define new value on client)!

I wonder if with Oracle you did the same "strange" and unsafe in
multi-user environment thing...
What prevents you from getting next 100 IDs from generator using ONE
call to GEN_ID(MyGen, 100) and then use them for inserting without any
loss in performance and in full safety?