Hi Daniel
I always read your posts with big interest and
almost everytime I share your opinions or point of
views.
However, in this specific case I cannot.
The reason is that I made some test with measuring
the times for the amount of time that is needed to
transmit data from a server to the client by ODBC.
To be honest - I didn't compare this ODBC speed
with other DB's, I only bulit my simple DCOM server
component (with VB) which was trasmitting all the data
from SAP DB to the client.
So I had two situations:
1. SAPDB Server --> CLIENT (SAP DB ODBC driver)
2. SAPDB Server --> DCOM Comp.(SAP DB ODBC driver) -> CLIENT( DCOM)
Transmitting data directly to client looked like
1. _________________________
_/ \_
whilst transmiting data in the second situation
2. /\
______________________________/ \______
DCOM takes results from DB; DCOM->Client
the network and all the machines configuration was the same.
So, this simple test showed me, that protocol which is used
to transmit data from SAP DB Server to the client by ODBC
must be rather inneficient.
Am I right??
Best regards,
Marcin
Uzytkownik "Dittmar, Daniel" <[EMAIL PROTECTED]> napisal w wiadomosci
news:[EMAIL PROTECTED]
> > do you know if ODBC is too slow?
> > I've find an older e-mail, they say that with ODBC SAPDB is
> > 10 times slowest
> > of MSSQL.
> > can you tell me if SAP have done some test with ODBC?
>
> One common problem is explained in
http://www.faqts.com/knowledge_base/view.phtml/aid/19487/fid/1119.
>
> This affects only the time required to create a connection.
>
> Other performance problems were either solvable (through UPDATE
> STATISTICS, changes to the optimizer) or occurred only in
> specific configurations (communication over modem).
>
> Daniel Dittmar
>
> --
> Daniel Dittmar
> SAP DB, SAP Labs Berlin
> [EMAIL PROTECTED]
> http://www.sapdb.org/
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
