Hi,
...
> Just curious, what kind of tables did you set up in MySQL? My
Ehh... there are more than one kind... I did not know. Still with
transactions on PostgreSQL (unsafe method?) MySQL was 2 times as fast as
PostgreSQL. I will check this out, and return to this list with the results.
...
> tables, then we're just back at the same old "speed versus data
> integrity" flame war that has always been the base of the
> MySQL/Postgres comparison.
Its a question of a compromising between speed and "integrity". *I think*
PostgreSQL should and could lower their "integrity" a bit (15 times slower).
...
> Of course, if they *were* Berkeley tables and you still got those
> results, then we'll need to dig a little deeper ;-)
I do not know, but I will find out.
// Jarmo
...
> > I wrote a piece of benchmarking, just to test my classes, and
> > was suprised of the speed diffs.
...
> > Inserts on MySQL : 0.71sec/1000 rows
> > Inserts on PostgreSQL: 10.78sec/1000 rows (15 times slower?)
> > Inserts on PostgreSQL*: 1.59sec/1000 rows (2 times slower?)
