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{

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

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

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 variables

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 bind

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) { print

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 continue with