Subject Re: [IBO] Slow stuff
Author Joe Martinez
I'm using 4.2 Gc.

-Joe

Jason Wharton wrote:

> What version of IBO are you using?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: "Joe Martinez" <joe@...>
> To: "IB Objects" <IBObjects@yahoogroups.com>
> Sent: Saturday, June 01, 2002 12:10 AM
> Subject: [IBO] Slow stuff
>
> > Since porting my app from BDE to IBO (TDataset-compatable objects), I
> > have noticed some things that seem to be a lot slower than they were
> > previously under the BDE.
> >
> > The first is calling Last() on a dataset, when starting from the first
> > record. It's taking about 1 minute on a 13,000 row dataset. The second
> > is doing a SetKey() and GotoKey() operation. This is taking about a
> > minute as well. Both of these took a lot less time before.
> >
> > Note, this slowdows only occurs on client machines, and NOT on the same
> > machine that the server is running on. This leads me to believe that
> > it's reading all of the records across the network connection just to
> > get to one particular record. If that is the case, why would it do
> > that? Shouldn't IBO just fetch the single record that I want? If that
> > is not the case, then why else would it be so slow? How can I speed it
> > up?
> >
> > Thanks,
> > Joe
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/