Re^2: Help prevent a ModPerl application from replacement by Java


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

Re^2: Help prevent a ModPerl application from replacement by Java

by monsieur_champs (Curate)

on Aug 30, 2005 at 02:50 UTC ( [id://487632]=note: print w/replies, xml )

Need Help??

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...

-- monsieur_champs

Comment on Re^2: Help prevent a ModPerl application from replacement by Java

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.

[reply]

In Section Seekers of Perl Wisdom