VFP 9 SP2 with MSSCCI: slow project loading

Question

Is it possible, that MSSCCI make VFP project loading slow? Project has 1000+ files, workspace is server. Project loads about 120+ seconds. Network traffic is greater during loading, CPU and memory no significant change. How can I optimalize loading project please?

SOLUTION:

NO, it seems that slow loading is consequence of using MSSCCI provider for little large projects source controlled in VFP.

Answer 1

We looked into moving from Visual SourceSafe to TFS a few years ago. When the VFP project was integrated with TFS, opening the project took longer than with VSS. There were also other oddities with the integration, such as not being able to see when a file was already checked out by someone else. We ended up abandoning the idea and stuck with VSS. That said, I wouldn't necessarily blame the MSSCCI provider. It probably has more to do with the way VFP queries source control data.

Note that you are not required to use the VFP project integration. You can use a separate source control client to check files in/out. You'll need a process for generating text versions of binary files (SCX, VCX, etc.).

FWIW, opening projects with VSS can also be slow. Upgrading our VSS server made a big difference. You may find the same if you are running TFS on an older/slower server.

Answer 2

I am not using it so I cannot directly comment on it.

A project is merely a table, and a project with 1000+ files would be roughly mean around 2Mb which is nothing for today's networking (even if it meant to bring down all that data). Normally it should open instantly or with 1-2 seconds delay at most (assuming you are not using an extremely slow network).

Answer 3

1. Please provide more details about your environment.
2. Make sure your TFS and MSSCCI are used latest version.
3. Try on another client machine to see whether your issue would be reproduced.
4. Create a new workspace to see whether the performance persists.