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!
coffeeteaAsked:
Who is Participating?
 
MindphaserConnect With a Mentor Commented:
Force accepted

** Mindphaser - Community Support Moderator **
0
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.