Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simulate wait state in vfpoledb
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01062636
Message ID:
01062757
Views:
21
Steve,

>This is working except for the problem outlined in my original message. The stored procedure needs to wait half a second or two between its data table interrogation or else the web server resources get gobbled up by the stored procedure I/O activity and brings the web server to its knees.

VFP is going to hog resources whenever it possibly can. Especially if you are executing a long running SQL-SELECT. You will be better off delegating this task off to another report server.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform