Re: DBI recipes

in reply to DBI recipes

I try the sample of "Binding a large hash" because perl is ten times slower than php to get data...and I lost 5 seconds!
- 349s in perl with "Binding a large hash" method
while ($sth->fetchrow_hashref)
- 344s in perl with while ( my $hash_ref = $sth->fetchrow_hashref)
- 32s in php with while ($row = db_fetch_array($statement,OCI_ASSOC))

Comment on Re: DBI recipes Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI recipes by mje (Curate) on Jan 25, 2010 at 09:02 UTC
As it looks as though you are using Oracle, you should go and get the latest release candidate (1.24 RC4) which can be found here as it contains fixes for retrieving multiple rows at a time. Also see Bug #46763 for DBD-Oracle: RowCacheSize is being ignored slowing and Bug #46998 for DBD-Oracle: Why is RowCacheSize limited to 128.	[reply]
Re^3: DBI recipes by Anonymous Monk on May 16, 2010 at 05:12 UTC
This seems to be treasure of DBI recipies --Prasad	[reply]
Re^2: DBI recipes by Anonymous Monk on Jan 24, 2010 at 22:34 UTC
Edit: ~~db_fetch_array~~ oci_fetch_array	[reply]

In Section Meditations