Perl - DBI - MSQL and Speed

[zCat]

---

System: The following 3 messages were cut out of thread at: http://www.webmasterworld.com/webmasterworld/3000001.htm [webmasterworld.com] by brett_tabke - 12:48 pm on July 9, 2006 (cst -5)

---

However, the core of WebmasterWorld is still written in Perl - which is notoriously slow

Aargh! It's statements like this that are chipping away at my Perl-based livelihood bit by bit... I'm guessing this is Perl running as a CGI script? That would be about as slow as say PHP running in CGI mode; implemented as mod_perl it's blazingly fast.

[Brett_Tabke]

lol zCat. Ya, it is DBI that is the slow dog in the race. I could not tell a difference between mod_perl and regular perl here. (I did not try DBI at the time though).

[zCat]

Ups, misread your original statement, apologies. With mod_perl the trick is to use Apache::DBI, that sets up a pool of reusable connections which saves on DB startup time (which will also depend on the DB server). I'd be interested to know what combination of Perl / DBI / database you are finding to be slow.

Congrats on the new forum version, at least when the teething troubles are over.

[Brett_Tabke]

DBI and MySQL. Generally, a significant over head involved. Sure, 50% of that is probably MySQL.

[zCat]

DBI and MySQL. Generally, a significant over head involved. Sure, 50% of that is probably MySQL.

When I have a moment I'll see if I can do some comparative tests.