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]