On Wed, May 02, 2001 at 06:18:08PM -0400, Phillip Perkins wrote:
> Tried that...no good. Still took 43 seconds, I think. I've watched it zip
> through all the records until it gets to the end where fetch returns undef, and
> that seems to be taking a while.
>
> I kinda' thought that it might be the connection, too, but obviously that's not
> the deal.
OK, let's summarize:
You have a .dbf file (no memo files?) with cca 900 records, you do
my $sth = $dbh->prepare(q!
select * from file
!);
$sth->execute;
while (my $data = $sth->fetchrow_arrayref) {
}
and you get those 900 records in reasonable amount of time (seconds).
But the next (last) fetch call that just returns undef takes 20
seconds itself. Do I get the situation right?
--
------------------------------------------------------------------------
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
------------------------------------------------------------------------
