Re: DBIx::Simple opinion..

does anyone has opinion or experience with DBIx::Simple in mod_perl env?

I do :-).

Comment on Re: DBIx::Simple opinion..

Replies are listed 'Best First'.
Re^2: DBIx::Simple opinion.. by Qiang (Friar) on Aug 28, 2007 at 16:11 UTC
i like to use `hashes` method in DBIx::Simple. however it is very inefficient and i am wondering why you don't use `bind_columns` as mentioned in DBI bind_columns personally i do it in the following way which eqivalent to fetchall_hashref. not sure how much efficient it is though. my (%row, @rows); $sth->bind_columns( \( @row{ @{$sth->{NAME_lc} } } )); while( $sth->fetch ) { push @rows, { %row }; }	[reply] [d/l] [select]
Re^3: DBIx::Simple opinion.. by Juerd (Abbot) on Sep 02, 2007 at 21:11 UTC
I haven't benchmarked it either. I recall having had reasons for not binding columns, but I don't remember the specifics. Juerd # { site => 'juerd.nl', do_not_use => 'spamtrap', perl6_server => 'feather' }	[reply]