Colud it be possible that the ODBC connection used by Access as the trace-log activated? This usually generates a lot of disk activity on the client, the trace is very verbose.
Regards, Martin -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com On 3/27/06, Mark Thomas <[EMAIL PROTECTED]> wrote: > Scott allowed me to see first-hand the problem Scott is describing. He is > not having connection difficulties at all. The problem is that a simple > single-row delete query on a 5-row table with a primary key takes over a > minute to complete when executed through Microsoft Access. There are no > other users connected at the time, so this is not the result of the row > being locked by another process. It simply takes that long to delete. The > same query, when executed through SQLStudio, is nearly instantaneous. > > For my part, I have never experienced this problem when executing queries > through Access. The most significant difference I've noted between our > environments is that our database runs on a 32-bit Linux server, whereas > Scott's is 64-bit Windows. > > "Henrik Hempelmann" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > On 25.03.2006, at 20:08, Scott Miller wrote: > > > >> ODBC uses ip address to connect to database and it does connect. > > > > > > ... and? > > How long does it take to get a negative answer for resolving the name of > > this IP-address? > > > > Henrik > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
