Yes, that is what I do... I select the next number and then alter the sequence to restart at that number + batch size.
73,
Matthew W. Jones (KI4ZIB)
http://matburt.net
On 31-08-2009 09:28:58 -0400, Matthew Jones wrote:do you know how many records come in advance? then you can just update
> I still have to be able to do that while continuously loading batches,
> and moving between tables like that will require me to lock out both
> tables while it is going on. Instead with my solution I only have to
> lock out the sequence for as long as it takes to generate the number
> and increment it, I just wish I didn't have to pay the cost at all at
> the client layer.
the sequence before you load, and hence avoid the possibility of
sequence numbers being returned that would be assigned to your batch.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users