---------------------- Weitergeleitet von Tom Zschockelt/Penig/Flender on 26.02.2003 11:40 ---------------------------
An: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Kopie:
Thema: RE: SAPDB vs. Microsoft SQL Server
Hello Tom,
please post the sourcecode of your mfc app. Because there are many pitfalls writting a
MFC driven application. Which Interfaces did your application use?
The definition of the table and what cursormodell, did your application use.
Does the connection goes over TCP/IP?
Regards,
Burkhard
Hi Burkhard,
after many hours of testing, I found some interesting facts about my performance-problems with sapdb.
In my first test I've used the mcf-class CDatabase and CRecordset to communicate with both sapdb and mssql.
Both goes over odbc-driver and tcp/ip in our 100 mbit network environment.
Because of I was not willing to depend on a special tableconfiguration I used the forward_only mechanism to perform
my sql-tasks. This brought me the bad results for sapdb.
After that I tested the other cursor-types and the direct use of the odbc-api.
And ...
I'm happy to say : sapdb is very very faster in the other cursor-types.
I had responsetimes of about 2.7 seconds with sapdb vs over 25 seconds with microsoft sql server.
But I'm not sure, why sapdb is as slow to perform a forward_only cursor
Bye
Tom
