>>>In WWC VFP servers, I opened about 35 files which are opened when WWC VFP servers start. Those are files I need for mostly all transactions. So, I open them up at first and only close them if a specific situation occurs. So, for each transaction, I don't have to open them up again. This is a time saver as I did the test by reopening them at each transaction and the time it takes is time I can't afford.
>>>
>>>My question is to know if there is an effect on VFP if I open more. Is 35 that much or I can open up to 50 without any problem?
>>
>>Some of our applications open over 100 at a time so I don't see it as a problem.
>
>You opened them at load time. Are you opening that all or some of them remain close?

We typically open 75-125 files at a time. In some cases we open them all at once, and in others we open them as we hit a need for them the first time. I haven't seen a problem with opening large numbers of files, and opening them to start seems to make sense. That said, sometimes it also makes sense to open them the first time you need them and then leave them open till you close. This method works fine under NT, but with Netware servers can cause a problem since netware seems to not like to open a lot of files (pretty strange for a straight file serving server if you ask me.)