Sequence numbers are actually pretty much obsolete in general and I do not understand why all those people use them. There are software algorithms out there, which do the job much better and with much less communication between client and database.
e.g. high-Low algorthim Marten Sven K�hler schrieb: > hi, > > i just got a shock while reading: > http://www.sapdb.org/how_tos/numbergen/howto_producenumgen_eng.htm > > > The use of a CREATE SEQUENCE is very complicated, as i have to use one > sequence per Table, or one for the whole database, which makes the > number grow very fast. I also have to use the Sequence on every INSERT > statement (and i cannot be sure, that the value of the column doesn't > change, right?) > > The other option is, to use DEFAULT SERIAL which was my favourite, > until i read, that i cannot get the value that was used. > > Is this solved in SAPDB 7.3? > Is a patch planned? > > Is it solved in v7.4? > when will it be released? > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
