>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only