All the Perl that's Practical to Extract and Report

SQLite vs MySQL vs PostgreSQL

Matts on 2003-01-28T12:02:14

Some very interesting performance comparisons here.

The only downside is that PostgreSQL is highly untuned in its default state, so I'm going to send the guy some tuning tips and hope he re-runs the test (SQLite will probably still be faster, but at least it'll be more reasonable).

MySQL in library mode?

barries on 2003-01-28T12:28:21

It would also be interesting to see what happens when you link directly to the MySQL library (if they have that deployment mode stable by now). I've been wondering "what if" my mod_perl processes used statically link MySQL code and no server, especially for read-mostly web sites.

- Barrie

Re:MySQL in library mode?

jnoble on 2003-01-28T15:19:33

Post what you send him please! I'm new to PostgreSQL, and interested in the points that you find key for tuning.

404

ask on 2003-02-03T13:48:24

http://www.sergeant.org/sqlite_vs_pg.html -> 404 Not Found.