On Wednesday 08 October 2003 18:03, Massimo Renzi wrote:
> Hi all,
> 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?
I have (until now) no real experience with SAPDB ODBC.
Anyway, I used (and still use) ADABAS-D 10.0 with the ADABAS-D ODBC drivers.
AFAIK ADABAS-D ist very similar to SAPDB, maybe the ODBC drivers also inherit
from the ADABAS-D ODBC drivers.
My experience with the ADABAS-D ODBC drivers is that they are indeed quite
slow compared to a native client and were (at least the Windows drivers)
quite buggy.
But the biggest problem for us was that the ODBC protocol needed a massive
bandwidth. We wrote a Client-Server application with an ODBC-connection from
a Windows workstation to a Linux-ADABAS-D server. One of our customers wanted
to connect the Client over a 64kbit ISDN line with the server and was very,
very disappointed because it was extremely slow. I still don't understand why
it was that slow: A single, short select statement that returned only one row
with about 100 characters lasted around 2 to 3 seconds. Some of our client
functions submitted ~ 30 SQL-selects but only transmitted ~ 5 kbytes and one
would have to wait minutes until the function responded.
We honestly considered writing a special daemon that would run on the ADABAS-D
Linux server and connect our client to this daemon with an own, simple text
protocol as this would have speeded up things a _lot_.
I still don't know if the reason for this behavior were the bad ADABAS-D
Windows drivers or simply the ODBC-protocol itself.
Anyway, it would be interesting, how SAPDB performs in this case but maybe we
will find out soon as we consider migrating our application from ADABAS-D to
SAPDB...
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]