Hi Erik,

>Some additional information- we have found that the difference is not in
>free/dbc tables, but in tables that another user has open. For tables that
>are already in use elsewhere, there is a 3-4 second opening delay. For
>tables where this WS is the only user, it's instant.

This changes the situation. I assume that there is a NT server in use as a network server. It has probably to do with the opportinistic locking mechanism.

See: Opportunistic Lock Examples in the Files and I/O platforms SDK on MSDN for further explanation.

To isolate the problem you might try to switch off opportunistic locking (ID: Q129202) and benchmark the results.

There seems to be some noise on the network when the server requests the other client to break up to level 2 or none. Bottom line: it may be the problem is at another workstation or the server instead of your workstation.

Walter,