See Msg 766371 ... It may be related to what you are seeing.

I'm not sure how to make that MsgId a link. Can anyone tell me how to do this?

Guy


>Hi Andrus
>>
>>It seems that file opening in server (USE command) takes a LOT of time in this case.
>
>This is something that I heard a few times in the last year.
>We had server-related perf problems, I traced it to Use as well.
>My main finding then was:
>it is only the *first* "use" of the *machine*, not of the *process*.
>Seems like there is some caching / synchonizing disagreeing on the OS level.
>
>My quick solution was to create another Form with a private datasession, and open each table there again if not open in this "caching form" already. PITA but effective. Another "solution" would be to open the needed tables in another process. From other source I've heard that other table commands, especially working with / updating views can result in less pronounced, but still "feelable" perf degradations (factor 2 to 3).
>
>>
>>Any idea why file opening from XP Pro is slow ?
>Nope. If you find anything, Pls. let me know.
>
>HTH
>
>thomas