Ian:

When I spoke about using FoxPro, I meant from within FoxPro, not through the
BDE. Right now I'm working with a Delphi program using Interbase through the
BDE. My comparison was with Visual FoxPro within a VFP program, and then it is
not a "wet dog", but it does run circles around anything I've seen so far with
what I'm currently working with.

Again, my question what kind of speed increase can I expect by accessing
Interbase directly via IBO?

Thanks,

Chuck

Ian Calway wrote:

> Hi,
>
> I have worked with visual foxpro in the past and found it to run like a wet
> dog. and tried to find the reason why and found that there are documented
> issues with the BDE and foxpro indexes that cause this problem. To get any
> speed out of the system I had to pump all the data to temp files and work
> with the temp files instead and then put the data back, very round-about way
> but still made a speed increase.
>
> Regards
> Ian Calway
>
> -----Original Message-----
> From: Ang Lik Huar [mailto:lhang@...]
> Sent: Wednesday, 18 April 2001 11:19 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] IBO speed vs BDE?
>
> Chuck,
>
> How can Foxpro is 100x faster than BDE ??
>
> -----Original Message-----
> From: Chuck Belanger [mailto:phytotech@...]
> Sent: Wednesday, April 18, 2001 8:05 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] IBO speed vs BDE?
>
> Daniel:
>
> We're using Interbase 5+
>
> Chuck
>
> Daniel Rail wrote:
>
> > What's your current database under BDE?
> >
> > Daniel Rail
> > Senior System Engineer
> > ACCRA Med Software Inc. (www.filopto.com)
> >
> > At 17/04/2001 18:43, you wrote:
> > >I'm in the middle of a project which has been using BDE access for all
> > >queries, updates, etc and we need to look at ways of improving
> > >performance. We have a number of instances where a cascading query is
> > >made on the record set (about 40K records now, but could grow in the
> > >next few years to several hundred thousand), i.e. keep querying a
> > >parent_id of a record to create a tree view or listing.
> > >
> > >Recently worked on a portion of the code that goes through the file to
> > >do this and to do all 35K items, it took 5-10 minutes, depending what
> > >other applications were using memory. My experience has been with Visual
> > >FoxPro which would easily be 100x faster than this.
> > >
> > >Does anyone have experience in comparing a IBO vs a BDE access speeds to
> > >give me a broad idea of what kind of speed increases we can get by
> > >replacing the BDE components with IBO?
> > >
> > >Thanks
> > >
> > >Chuck Belanger
> > >
> > >
> > >Yahoo! Groups Sponsor
> >
> ><http://rd.yahoo.com/M=162801.1342250.2934640.1280005/D=egroupmail/S=170000
> 7183:N/A=599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLe
> rt_ComputersInternet_Software_WhiteGridTime&t=ad>
> > >Click Here to Find Software Faster
> > >
> > >Your use of Yahoo! Groups is subject to the
> > ><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
> [Non-text portions of this message have been removed]
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
> Yahoo! Groups Sponsor
>
> Click Here to Find Software Faster
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

[Non-text portions of this message have been removed]