2005/9/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > Robert wrote: > > > 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. > > The measure was done by the SQL-Trace of the MAX-DB-ODBC Driver. > I can see DISCONNECTS between each during the 5 second pause time. > Can I get rid off these DISCONNECTs ?
That you better ask that in a MS Access forum. I'm sure there is a newsgroup related to this. Online documentation might help, too. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]