Solved

Why is obviously lower by ADO connection than by BDE connection with Sybase?

Posted on 2002-06-14
12
260 Views
Last Modified: 2013-11-23
  Now my work adope ADO connection instead of BDE connection,but I find out that the spped is obviously lower by ADO connection than by BDE connection,my SQL Server is Sybase,Do ADO driver or other result in lower speed?
   why is by ADO connection lower?I want to get your help!Can you help me?Thanks in advance!
0
Comment
Question by:coffeetea
  • 5
  • 3
  • 2
  • +2
12 Comments
 
LVL 45

Expert Comment

by:aikimark
ID: 7078130
Were you connecting to the same database through BDE as you are with ADO?  If not, I'd say it was network time and connection handshaking.
0
 
LVL 22

Expert Comment

by:mnasman
ID: 7079470
Hello

  I tried ADO and BDE with oracle database, the ADO faster than BDE by more than 50% as I tested

  But you need to use the ADO Native drivers, not ODBC, which drivers you are using for the Sybase?
0
 

Author Comment

by:coffeetea
ID: 7080123
to mnasman:
  I use ADO driver for Sybase downloaded on Sybase homepage,more over,I use native drivers in deed not ODBC driver!but I think it result from ADO driver!I tried ADO and BDE with SQL server database, the ADO faster than BDE as I tested ever!All that are adope the same way!
0
 

Author Comment

by:coffeetea
ID: 7080127
to aikimark:
  If as you said,why I use SQL Server not?I adope the way by connect database when system starts everytime!I all along feel that I think it result from ADO driver!
  I wait for your answer!
0
 
LVL 45

Expert Comment

by:aikimark
ID: 7080368
coffeetea,

I think I might have misunderstood your question/problem.

Do I understand correctly:
1. You are connecting your Delphi application to a Sybase database.
2. You have replaced the BDE/ODBC Sybase connection with the ADO provider you downloaded from the Sybase site.
3. The process of connecting to the database performs slower (requires more time) with the ADO access than with the BDE/ODBC access.
4. Retrieving records/rows is not a performance issue, just the connection process.

Q1. What version of Delphi are you using?
Q2. Are you using dbExpress?
0
 

Author Comment

by:coffeetea
ID: 7081284
aikimark:
  I answer your question at first:
  Q1:I use Delphi 5;
  Q2:No,I only use ADO Express;
  I think what I said isn't so clear that you misunderstand my two points for 3 and 4:
  1.The process of connecting to the database dosen't performs slower (requires more time) with the ADO access
than with the BDE/ODBC access.
  2.Retrieving records/rows is a performance issue, just the connection process.Retrieving records/rows is lower by ADO connection than by BDE connection.
  thank for your help!:)

0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 22

Expert Comment

by:mnasman
ID: 7081337
Hello

  dbExpress is new techology from Borland, and it's not based on the ADO, so there's no relation between them

and if you would to use dbExpress, you need Delphi 6 Enterprise or Kylix


  try to find some information about sybase ado provider drivers, may it has some bugs that make it slow like this way,

the faster way to connect to any kind of database is using direct access drivers, you can find one for sybase here, but it's not free
http://www.microolap.com

Best regards
0
 

Author Comment

by:coffeetea
ID: 7081384
mnasman:
   thank you!I will have a try tomorrow!
0
 

Author Comment

by:coffeetea
ID: 7083463
mnasman:
  It seem that it is useless by dowlowed drivers from the site that you provided!
  Thank you!
0
 
LVL 45

Expert Comment

by:aikimark
ID: 7083613
What version of ADO are you using?
What version of Sybase OLEDB Provider are you using?
What does your database connectivity code/parameters look like?
What does your row-retrieval code look like?

==============================================
I must admit that I haven't found anything obvious that would lead to a row retrieval problem given the information you've supplied.
0
 
LVL 1

Expert Comment

by:pnh73
ID: 9010889
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ and No Refund

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 9102399
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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…
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

706 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

18 Experts available now in Live!

Get 1:1 Help Now