2005/9/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > 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. HTH robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
