?
Solved

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

Posted on 2002-06-14
12
Medium Priority
?
269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +2
12 Comments
 
LVL 46

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:Mohammed Nasman
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 46

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

Expert Comment

by:Mohammed Nasman
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 46

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
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 is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month10 days, 3 hours left to enroll

762 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