All the Perl that's Practical to Extract and Report

Mmm, MySQL

krellis on 2002-02-12T16:29:22

So I cut the run time of this CGI which generates org charts out of a database from 30 seconds to 1 second by changing the database it feeds out of from Oracle to MySQL. Lesson of the day today: MySQL's simple SELECT performance really IS much better than Oracle's. Time to install the cronjob to dump the data out of Oracle into MySQL weekly!

Are you sure it's faster?

djberg96 on 2002-02-16T02:33:46

Not a huge Oracle fan or anything here, but might it have to do with the size of the Oracle table and whether or not it's indexed?

Re:Are you sure it's faster?

koschei on 2002-02-19T02:08:04

If the Oracle install is anything like the one I had to use a year or two ago, most of the 30 seconds is spent just connecting to the database (authenticating etc.)