Hello guys
I have two Pallets one with some ado components and other named dbexpress.
I'd like to know what is the difference between them and which them is better?
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
actually, BDE (borland database engine) is the older version of DBExpress.
Main difference is that DBExpress is cross-platform where ADO is only supported by microsoft OS. ADO will work without anything else, where DBExpress/BDE requires installation of a middleware (that can be included in your setup of your applications).
then, dbexpress component replaced the BDE pallet with a superior tecnology, am I right?
something that intriguis me is that when I make a query like this:
select * from clients
I noticed that using ADO query, it is loaded in my memory almost 60 mb although on the other hand when I use dbexpress, it is load in memory almost 15 mb.
Why?
ADO is likely to use more memory because it is based on variants and activeX interfaces, where DBE is native Delphi
maybe also the implementation of the Query object does not load all the results in memory but only the first ones (I know that some Oracle DB comps use this technique when large results sets are returned). Try displaying all the results or do Query.Last to be sure that you compare equals things
If not for comparing memory usage, you don't have to bother with this. BDE and visual controls does it for you.
Only thing you can see is the fact that when you use the scrollbar to see the end of the results, some lag could occur because BDE is requesting the remaining data. But that's not an issue, as it will also prevent large amount of data to explode your memory and make the user waits minutes before viewing the start of it. I've seen it happen a few time, and I'm thankful for BDE implementation as it usually works better.
Business Accounts
Answer for Membership
by: bob_the_builderPosted on 2009-10-19 at 05:02:56ID: 25604356
This post should answer your questions!
http://www.delphipages.com
Cheers,
Bob...