• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

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

  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
coffeetea
Asked:
coffeetea
  • 5
  • 3
  • 2
  • +2
1 Solution
 
aikimarkCommented:
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
 
Mohammed NasmanSoftware DeveloperCommented:
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
 
coffeeteaAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
coffeeteaAuthor Commented:
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
 
aikimarkCommented:
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
 
coffeeteaAuthor Commented:
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
 
Mohammed NasmanSoftware DeveloperCommented:
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
 
coffeeteaAuthor Commented:
mnasman:
   thank you!I will have a try tomorrow!
0
 
coffeeteaAuthor Commented:
mnasman:
  It seem that it is useless by dowlowed drivers from the site that you provided!
  Thank you!
0
 
aikimarkCommented:
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
 
pnh73Commented:
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
 
MindphaserCommented:
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 5
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now