Clayton Cottingham aka drfrog wrote:
>
> [drfrog]$ perl fast_db.pl
> postgres
> 16 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 400.00/s (n=20)
> mysql
> 3 wallclock secs ( 0.07 usr + 0.00 sys = 0.07 CPU) @ 285.71/s (n=20)
> postgres
> 17 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 333.33/s (n=20)
> mysql
> 3 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 1000.00/s (n=20)
[snip]
> not using any optimizing techs at all i'll post the
>
> config scripts i use
Could you post the SQL statements used to create the tables as well?
I have a server here with Oracle 8.1.7, MySQL 3.23.36, and PostgreSQL
7.0.3. I'd love to extend your fast_db.pl script to support Oracle as
well, just for comparisons sake. I also wonder how the benchmarks would
differ if placeholders were used, allowing the RDBMS to cache the
compiled query...
After running the test, I'll upgrade to PostgreSQL 7.1 and see how the
numbers differ from 7.0.
--
Regards,
Wim Kerkhoff, Software Engineer
Merilus, Inc. -|- http://www.merilus.com
Email: [EMAIL PROTECTED]
