Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

use Perl Log In

[ Create a new account ]

krellis (2720)

krellis
reversethis-{gro.sillerk} {ta} {mit}
http://www.krellis.org/
AOL IM: KrellisOffice (Add Buddy, Send Message)

Perl geek, FreeBSD sysadmin, DNS know-it-all

Journal of krellis (2720)

Tuesday February 12, 2002

11:29 AM

Mmm, MySQL

[ #2814 ]

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!

List all Journal entries

Mmm, MySQL More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Are you sure it's faster? (Score:0)

by djberg96 (2603)

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? (Score:1)
  
  by koschei (147)
  
  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.)
  
  --
  ---ict / Spoon

Get More Comments

Reply

use Perl

All the Perl that's Practical to Extract and Report

Navigation

use Perl Log In

krellis (2720)

Journal of krellis (2720)

Mmm, MySQL

Mmm, MySQL 2 Comments More | Login | Reply /

Please Log In to Continue

Are you sure it's faster? (Score:0)

Re:Are you sure it's faster? (Score:1)