Haha !, nice one Claudio !

Of course you are right, but let's say that all your rain and snow parameters are assumed to be optimal. So, it's dry (well, it sure isn't overhere today ...).
I only want to say that in order to have "speed" one must met the conditions for it, and IMHO the question was : is the x secs for so few files normal. Well, it isn't, but of course, if I test this on my W95 machine without rebooting it for 10 days, it is, and I have my disk full because of the swapfile. Note : I didn't reboot my PC in advance, but I have W2K (IMO) not subject to such stupidness. However, of course you are right.

So again, I only tried to present my figures, which are in an optimized environment, with btw only one physical disk in the server (see other message) because one burned down the other day. But, this doesn't matter since I claimed that all was in the server's cache anyhow. So yes, that difficult it is indeed.
BTW, in my environment the 100Mbit is the bottleneck. Make it GH network, and the server's processor will be. Etc etc etc.

Maybe I just met someone who recognizes this all ... ;))







>Hi Peter;
>
>>In some existing more heavy function we open 69 tables at one time, and since all have a CDX, this comes to 138 physical files (no Memos).
>>With our 1GH server, 950Mhz client, 100Mbit network, this opens in (about) 1.267 secs, but knowing that the according diskblocks to load will already have been cached at the server (this can't be cached at the client !). This is for the Dos-app and the Win app just the same (so Win is not faster as I stated earlier, but for sure not more slow too).
>>
>
>There is thousand of variables envolved in this equation:
>
>

>PETER'S ENVIRONMENT------------------    KEVIN'S ENVIRONMENT------------
>1     -  GHZ processor                   ?    - Ghz processor
>100   -  Mbit network                    ?    - Mbit network
>69    -  Tables                          11   - Tables
>138   -  Physical files                  ?    - Physical files
>?     -  Speed of harddisk               ?    - ditto
>?     -  RAM server                      ?    - ditto
>?     -  RAM client                      ?    - ditto
>?     -  Windows Memory                  ?    - ditto
>?     -  Other client's Applications     ?    - ditto
>?     -  Other NT's tasks                ?    - ditto
>--------------------------------------   --------------------------------
>

>
>Last considerations:
>. Is there NT or any other systems and both environment of servers/clients
>. This is raining or not, this is snowing or not, for how many hours you are in the computer (these subjects are worth for systems of Microsoft) :))
>
> ..and a lot, much more. So, questions like this will still be a mystery for a lot, a lot of centuries.
>
>Claudio