Re: fetch or fetch hash/array ref?

2006-11-07 Thread Tim Bunce
On Mon, Nov 06, 2006 at 04:08:40PM -, [EMAIL PROTECTED] wrote: > On 6 Nov 2006 at 15:08, Also Sprach Tim Bunce: > > > Exactly. Also keep in mind the combined approach using bind_columns: > > > > $sth->execute; > > my %row; > > $sth->bind_columns( \( @row

Re: fetch or fetch hash/array ref?

2006-11-06 Thread Peter J. Holzer
On 2006-11-06 14:37:20 -, [EMAIL PROTECTED] wrote: > On 6 Nov 2006 at 14:12, Also Sprach Peter J. Holzer: > > On 2006-11-06 11:58:44 -, [EMAIL PROTECTED] wrote: > > > I'm currently, for speed, using execute, bind_columns, fetch. [...] > > > So, given that speed is paramount, should I conti

Re: fetch or fetch hash/array ref?

2006-11-06 Thread john1
On 6 Nov 2006 at 15:08, Also Sprach Tim Bunce: > Exactly. Also keep in mind the combined approach using bind_columns: > > $sth->execute; > my %row; > $sth->bind_columns( \( @row{ @{$sth->{NAME_lc} } } )); > while ($sth->fetch) { >

Re: fetch or fetch hash/array ref?

2006-11-06 Thread Tim Bunce
On Mon, Nov 06, 2006 at 02:12:09PM +0100, Peter J. Holzer wrote: > On 2006-11-06 11:58:44 -, [EMAIL PROTECTED] wrote: > > I'm currently, for speed, using execute, bind_columns, fetch. > > However, the number of columns I will be fetching is going to > > increase. This is a pita for defining b

Re: fetch or fetch hash/array ref?

2006-11-06 Thread john1
On 6 Nov 2006 at 14:12, Also Sprach Peter J. Holzer: > On 2006-11-06 11:58:44 -, [EMAIL PROTECTED] wrote: > > I'm currently, for speed, using execute, bind_columns, fetch. > > However, the number of columns I will be fetching is going to > > increase. This is a pita for defining bind variabl

Re: fetch or fetch hash/array ref?

2006-11-06 Thread Peter J. Holzer
On 2006-11-06 11:58:44 -, [EMAIL PROTECTED] wrote: > I'm currently, for speed, using execute, bind_columns, fetch. > However, the number of columns I will be fetching is going to > increase. This is a pita for defining bind variables etc. > So, given that speed is paramount, should I continue

fetch or fetch hash/array ref?

2006-11-06 Thread john
I'm currently, for speed, using execute, bind_columns, fetch. However, the number of columns I will be fetching is going to increase. This is a pita for defining bind variables etc. So, given that speed is paramount, should I continue with this method or should I switch to fetch hashref? Thx J