Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
Re: Performance problem MS Access <> SAP-DB
From: Robert Klemme (shortcuttergooglemail.com)
Date: Mon Sep 26 2005 - 11:06:28 CDT
2005/9/26, dummyhabmalnefrage.de <dummyhabmalnefrage.de>:
> Hi all,
> I have a performance problem between SAP-DB 7.4.03.32 (SLES-7), Windows XP
> MS Access 2002 (10.xx), ODBC-Driver MAX-DB 7.5.
> As far as I can see from the SQL-Trace of the ODBC-Driver the requests to
> the SAP-DB will be answered in 1 second. The time between one SQL-Command
> and the next SQL-Command issued by Access is about 5 seconds!
How did you measure the 1 second? If it was done with a different
tool than Access it may be that Access needs five seconds to process
the result (and probably do other stuff as well). For example if it
has to update a complex UI or such.
If Access would do a connect per select than that would explain a lot, too.
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb