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]

Reply via email to