Kris Jurka wrote:
>On Tue, 2 Nov 2004, Alan Stange wrote:
>>>This is something (as discussed with Dave) that you shouldn't be doing,
>>Let me be devils advocate for a second and ask "why not"? I don't
>>disagree, but I'm not sure I understand all the issues here.
>The real problem is that executeBatch() returns an int of update counts.
>What should we return for an entry like addBatch("INSERT ... ; INSERT
>..."); ? Two individual entries? The sum of the update counts? The
>javadoc for executeBatch isn't entirely clear, but certainly seems to make
>the assumption that one batch entry is one command.
This was what I was thinking. What does the pg74 driver do in this
case as it does allow multiple statements in each batch?
> Especially since you
>are already using addBatch, there doesn't seem to be much point in jamming
>two commands into one batch.
Network latency. We were able to greatly increase performance this way
by reducing the number of round trips.
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2004-11-02 20:29:01|
|Subject: Re: executeBatch() issue with new driver?|
|Previous:||From: Kris Jurka||Date: 2004-11-02 20:09:38|
|Subject: Re: 1300 to 3100 lines of code for XA support (was: Re: plans|