>I have a web program that is using a vfp com component with asp pages. The component was built as multithreaded, and is running on a windows 2000 server with duel processors. The component is opening and accessing about 30 tables over a 100mb network shared(both reading and writing on various tables). My problem is, when I have about 200 concurrent users accessing the web and using the dll, it sends the utilization up to 50% and locks the machine forcing me to reboot about every 2 hours. Has anyone else experienced similar issues?, is this a threading issue?, or do I need to issue any other set commands besides exclusive & resource to manage it. I would appreciate any help on this. Thanks.
What exactly is happening when you lock up? CPU Utilization of 50% for what - 1 of the processors? or 50% for both (100% for one of them)?
Are you running in MTS?
There is a very serious bug in VFP 6 SP3 and Windows 2000 that will cause VFP COM components to lock up randomly, especially with MTS, but it will happen with standalone components as well. Microsoft has fixed this internally and it's slated for the next service pack (past SP4) but I think you can get a hotfix for this by calling support services if you have a reproducible scenario.