[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-users
Subject: Re: [MonetDB-users] COPY...INTO with auto increment
From: Matthew Jones <mat () matburt ! net>
Date: 2009-08-31 14:59:23
Message-ID: 773b85130908310759jd9d22c3v59a1f7687cd29651 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 Mon, Aug 31, 2009 at 10:50 AM, Fabian Groffen <Fabian.Groffen@cwi.nl>wrote:
> On 31-08-2009 09:28:58 -0400, Matthew Jones wrote:
> > 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.
>
> do you know how many records come in advance? then you can just update
> 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
>
[Attachment #5 (text/html)]
Yes, that is what I do... I select the next number and then alter the sequence to \
restart at that number + batch size.<br><br clear="all">73,<br>Matthew W. Jones \
(KI4ZIB)<br><a href="http://matburt.net">http://matburt.net</a><br>
<br><br><div class="gmail_quote">On Mon, Aug 31, 2009 at 10:50 AM, Fabian Groffen \
<span dir="ltr"><<a \
href="mailto:Fabian.Groffen@cwi.nl">Fabian.Groffen@cwi.nl</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, \
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On 31-08-2009 09:28:58 -0400, Matthew Jones wrote:<br>
> I still have to be able to do that while continuously loading batches,<br>
> and moving between tables like that will require me to lock out both<br>
> tables while it is going on. Instead with my solution I only have to<br>
> lock out the sequence for as long as it takes to generate the number<br>
> and increment it, I just wish I didn't have to pay the cost at all at<br>
> the client layer.<br>
<br>
</div>do you know how many records come in advance? then you can just update<br>
the sequence before you load, and hence avoid the possibility of<br>
sequence numbers being returned that would be assigned to your batch.<br>
<div><div></div><div class="h5"><br>
------------------------------------------------------------------------------<br>
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day<br>
trial. Simplify your report design, integration and deployment - and focus on<br>
what you do best, core application coding. Discover what's new with<br>
Crystal Reports now. <a href="http://p.sf.net/sfu/bobj-july" \
target="_blank">http://p.sf.net/sfu/bobj-july</a><br> \
_______________________________________________<br> MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br> \
</div></div></blockquote></div><br>
------------------------------------------------------------------------------
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic