Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Interop Code Hogs the Server
Message
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
ASP.NET
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01026504
Message ID:
01028034
Views:
17
>One more question if you don't mind. Do you know if it's possible to limit VFP threads to one processor at a time on a dual or quad machine?

What I do to sorta force this is have a report server executable running on my webservers. The EXE monitors a table for any requested reports, then executes them. ASP.NET and VFP DLL componets can put report requests into this table. The benefits of this are:
- the system only executes 1 report (or X reports if X report servers are running). This prevents the webserver becoming overwhelmed with several reports at once
- the report server only uses the resources of 1 CPU, leaving the other CPUs free to serve ASP.NET requests

Also, for very long running reports, I compile all or a portion of the data each night at midnight. Reports requests during the day use this precompiled data.
Previous
Reply
Map
View

Click here to load this message in the networking platform