Solved

ADO vs. BDE accessing SQL2000

Posted on 2001-06-17
9
701 Views
Last Modified: 2013-11-23
I am faced with a technical question that seems to have no clear cut answer.  I have a lot of old poorly written code around an Interbase 5.0 database.  I have ported my data to SQL 2000, but I am being told that I should also convert the data access within the old code from BDE to ADO due to limitations with Stored Procs.  Now, I understand I will gain a lot from rewriting the data access, like instituting a standard data module and documenting some of the spaghetti.  However, I think I might want to wait on the data access conversion and just try to use the BDE TTable components and connection ratehr than changing everything to ADO right now.  Some of my programmers say I should convert it to ADO and some do not.  It will cost more money and time to do the ADO conversion.  

Is there a definitive right answer to the question: Must I convert data access to ADO when going form an Interbase backend to a SQL 2000 backend?

Thanks
0
Comment
Question by:ARW
9 Comments
 
LVL 2

Expert Comment

by:danysz
ID: 6200842
hi

yes for sure u shall move to ADO and also if u move to Delphi 6 u shall stop using the BDE. From what Borland said they going to renounce to use slowly ...

Daniel
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6201016
i would prefer to use ado with a sql2000 server
0
 
LVL 1

Expert Comment

by:WiseGuy
ID: 6201138
I am using ADO queries and an occasional table against SQL2000 and I have also used the same code against Interbase. 'Going' from Interbase to SQL2000 was not painless.

From my point of view you ''ll have to choose between
    known paths and a technology that's at the end of its evolution
or
    Using technology that is new to you, but which is (or will be) ready for future developments
0
 

Expert Comment

by:reuveni
ID: 6202043
We are developing D5 application using SQL Server
and BDE and untill now we didn't see any major problems.
We are also writing Triggers and Stored Procedures.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 1

Accepted Solution

by:
bozo7 earned 200 total points
ID: 6202269
One issue with using BDE with SQL. The BDE can only have one active at a time. I ran tests on this I made an application with 2 ADO queries and 2 BDE queries (both doing select *) here are the results:
Table1 300,000 records
Table2 25,000 records
     Query1      Query2
ADO    15 sec      10 sec
BDE    10 sec       5 minutes

The problem with the BDE is that it must cache the first query locally before it can open the second query. Which defeats the purpose of a client server design.
I now use ADO with SQL 2000. It works just great.

Hope this helps
Ross
0
 

Author Comment

by:ARW
ID: 6207426
Thank you for supporting answer with empirical data.

arw
0
 
LVL 1

Expert Comment

by:WiseGuy
ID: 6209236
bozo7,

Are you sure that when you run a seperate thread with its own session, the BDE cannot have two queries active?

Ramon
0
 
LVL 1

Expert Comment

by:bozo7
ID: 6210280
If it is two threads with a seperate session it is probably fine. But I did not see that issue brought out. Besides a thread can not update the user interface of the main thread. So the programming of the threads would be far more complicated than switching to ADO, in my opinion.
Ross
0
 
LVL 1

Expert Comment

by:WiseGuy
ID: 6213191
You're absolutely right there Ross, but its a different argument for the same answer.

Anyway, enough hair splitting

CU, Ramon
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now