coffeetea
asked on
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!
why is by ADO connection lower?I want to get your help!Can you help me?Thanks in advance!
aikimark
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.
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?
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?
ASKER
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!
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!
ASKER
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!
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!
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?
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?
ASKER
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!:)
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!:)
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
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
ASKER
mnasman:
thank you!I will have a try tomorrow!
thank you!I will have a try tomorrow!
ASKER
mnasman:
It seem that it is useless by dowlowed drivers from the site that you provided!
Thank you!
It seem that it is useless by dowlowed drivers from the site that you provided!
Thank you!
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.
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.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.