Just tried it out... Still takes 25 seconds to do a fetchall_arrayref. This is
on a query that returns 994 records of 22 fields. Then I did another that did 1
record of 69 fields...and it took 46 seconds. Is it just the machine that it's
on? I am getting the data off of a Novell mounted server drive... I have yet to
dig down into the guts of the modules to see how it pulls data from the DBF file,
but I'm hoping to avoid this.
TIA
Phillip
Phillip Perkins wrote:
> Okay, sorry in my last email. I put down wrong version numbers. However, I'm
> updating XBase, DBD::XBase, and DBI. Gonna' give it a whirl...
>
> Phillip
>
> "Sterin, Ilya" wrote:
>
> > Phillip did send an example yesterday. Look in your email or the archives.
> >
> > Ilya Sterin
> >
> > -----Original Message-----
> > From: Honza Pazdziora
> > To: Phillip Perkins
> > Cc: [EMAIL PROTECTED]
> > Sent: 05/02/2001 1:46 AM
> > Subject: Re: Last fetch takes forever to undef under XBase
> >
> > On Tue, May 01, 2001 at 11:36:49AM -0400, Phillip Perkins wrote:
> > > Here's a question I hope someone can answer for me. When using DBI to
> > > query a table, the query takes only milliseconds. However, if you do
> > > any type of fetch on an sth, when you reach the EOF ($sth->fetch is
> > > undef), it takes a while before it fails and, for instance, exits a
> > > while loop. Same thing happens if you do a fetchall_arrayref. Can
> > > anyone explain to me while this takes so long and possibly how to
> > > overcome it? By the way, I'm using an XBase connection, so it may be
> > > relative to that module.
> >
> > Moved to dbi-users.
> >
> > Please mention the name of the driver in Subject, I got to read this
> > by a sheer luck.
> >
> > Please post five line example of this problem, together with version
> > numbers of your software -- I'm unable to repeat the behaviour here.
> >
> > Thanks,
> >
> > --
> > ------------------------------------------------------------------------
> > Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
> > .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
> > ------------------------------------------------------------------------
