No, it is one transaction per insert.
-----Original Message-----
From: Scott Marlowe [mailto:smarlowe(at)g2switchworks(dot)com]
Sent: Tuesday, May 08, 2007 5:38 PM
To: Orhan Aglagul
Subject: RE: [PERFORM]
On Tue, 2007-05-08 at 19:36, Orhan Aglagul wrote:
> But 10,000 records in 65 sec comes to ~153 records per second. On a
dual
> 3.06 Xeon....
> What range is acceptable?
If you're doing that in one big transaction, that's horrible. Because
it shouldn't be waiting for each insert to fsync, but the whole
transaction.