Solved

ADO vs. BDE accessing SQL2000

Posted on 2001-06-17
9
710 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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
 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

839 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