On Nov 25, 2003, at 2:18 PM, Brad Perkins wrote:
Hi. We've just started experiencing this problem today...
We have a few database-intensive reports being generated by Active4D.
Whenever one of these reports is being generated, it appears that Active4D [on the server] is dominating the server's CPU, so that everyone else's processes are getting crowded out. My coworker says that, when doing database-intensive operations, processes [at least from Client] are throttled. I suggested that, since Active4D is a plugin, it's not as strictly bound by the 4D Scheduler. Are we on the right track, or barking up the wrong tree?
David,
A few ideas.
Do any of these reports use any other plug-ins? For example, are you using 4DIC to send mail or to transfer a file via FTP?
The only plugins we have installed are:
4D Pack 4D_InternetCommands Active4D Backup
A few of our lesser-used pages send small emails. The SMTP server that gets used is localhost.
Have you used 4D's Runtime Explorer to see what's happening with available memory or your database's cache when these reports are running? That could let you know if you need change server memory or cache settings.
We've been unable to track that. What happens is: the computer's CPU usage [as witnessed by the Activity Monitor utility] jumps to 100% on the server, and the 4D Server user interface becomes unresponsive [pinwheel of death]. We only regain control over the UI after the CPU usage has gone back down.
- D
