Are there known limits to how many rows can be inserted by one
transaction, or does that just reflect the already documented row,
table and database limits?
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be able to roll back the transaction, so
at some point your system will grind to a
On 10/21/05, Richard Huxton dev@archonet.com wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be able to roll back the
On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote:
On 10/21/05, Richard Huxton dev@archonet.com wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one
transaction,
Well, the system will need to be able to roll back the transaction,
Nicolas Barbier wrote:
On 10/21/05, Richard Huxton dev@archonet.com wrote:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Well, the system will need to be
jeff sacksteder [EMAIL PROTECTED] writes:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?
Offhand I think the only limit that might concern you is the CID limit
of 2^32 SQL commands per
MaXX [EMAIL PROTECTED] writes:
jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one
transaction, or does that just reflect the already documented row, table
and database limits?
An error string in the source code stands:
cannot have more than 2^32-1
Chris Browne [EMAIL PROTECTED] writes:
MaXX [EMAIL PROTECTED] writes:
An error string in the source code stands:
cannot have more than 2^32-1 commands in a transaction
That means you couldn't do more than 2^32-1 INSERT statements.
Right.
But that wouldn't (in principle) prevent having each