Using IBO gives you a direct connection with the Interbase server and
doesn't need the BDE. The BDE uses resources and memory that isn't
necessary. Also, there is documentation regarding the difference in speed
between IBO and BDE. What I've read was that IBO is between 50-200 times
faster than the BDE and I can vouch for that. It still depends on how you
construct your queries and use the resources at your disposition at the
server level(i.e. stored procedures and triggers). Also, you can do some
tweaking on the server settings and a little at the client level.

Hope this helps.

Daniel Rail

At 17/04/2001 21:05, you wrote:

>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=1
> 700007183:N/A=599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_ComputersInternet_Software_WhiteGridTime&t=ad>http://rd.yahoo.com/M=162801.1342250.2934640.1280005/D=egroupmail/S=1700007183:N/A=599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_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/>http://docs.yahoo.com/info/terms/>Y
> ahoo! Terms of Service.
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/
>
>
>[Non-text portions of this message have been removed]
>
>
>Yahoo! Groups Sponsor
><http://rd.yahoo.com/M=162801.1342250.2934640.1280005/D=egroupmail/S=1700007183:N/A=599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_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.