Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: Re: Re: Speed of Templateby arturo (Vicar) |
on Feb 09, 2001 at 20:58 UTC ( [id://57410]=note: print w/replies, xml ) | Need Help?? |
As far as getting the column titles out correctly goes, I'd suggest something along the lines of putting as much of your DBI stuff in a single module (an OO one if you like) as possible. That allows you to 'encapsulate' (love that buzzword) your database code. In that module, or elsewhere, you could use the constant pragma to alias column numbers to memorable tags. You'd only have one place you'd have to change, and you'd get the speed advantages of fetchrow_array over fetchrow_hash. e.g. :
Or some such. Just a thought. Philosophy can be made out of anything. Or less -- Jerry A. Fodor
In Section
Seekers of Perl Wisdom
|
|