http://www.perlmonks.org?node_id=487632


in reply to Re: Help prevent a ModPerl application from replacement by Java
in thread Help prevent a ModPerl application from replacement by Java

The profiler data (posted with the original question) states this. But I'll have a hard and dull drawback on not using it: my column names and table names are not intuitive nor easy to guess. This would be a pain to write SQL to them. But it seems better than dropping Perl in favor of Java.

My hope is not need to do this. Maybe someone have a good suggestion that allows my Perl to fly...

Replies are listed 'Best First'.
Re^3: Help prevent a ModPerl application from replacement by Java
by Jenda (Abbot) on Sep 02, 2005 at 16:28 UTC

    Maybe it's just me, but I do think that (as soon as the database server allows that) all SQL should be in stored procedures. Snippets of SQL scattered throughout the Perl (or VB or C or Java or whatever you use) code are a major PITA as soon as you have to make some changes in the database schema. Plus this allows the server to store the execution plans which is even better than caching them.

    Jenda
    XML sucks. Badly. SOAP on the other hand is the most powerfull vacuum pump ever invented.