On Tue, 2003-02-11 at 08:31, Mario Weilguni wrote:
> >Hrm.  I just saw that the PHP ADODB guy just published a bunch of database
> >benchmarks.  It's fairly evident to me that benchmarking PostgreSQL on
> >Win32 isn't really fair:
> >http://php.weblogs.com/oracle_mysql_performance
> And why is the highly advocated transaction capable MySQL 4 not tested?
> That's the problem, for every performance test they choose ISAM tables, and
> when transactions are mentioned it's said "MySQL has transactions". But why
> no benchmarks?

Insert Statement

Not using bind variables (MySQL and Oracle): 

Using bind variables: 

PL/SQL Insert Benchmark
Appears to not initiate a transaction.  I'm assuming this is because
it's implicitly within a transaction?  Oddly enough, I am seeing
explicit commits here.

It appears that the benchmarks are attempting to use transactions,
however, I have no idea if MySQL's HEAP supports them.  For all I know,
transactions are being silently ignored.


Greg Copeland <[EMAIL PROTECTED]>
Copeland Computer Consulting

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to