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.
What other applicitions are you running on the server (can I assume at least a mail server)? You didn't mention platform, OS, 4D version, etc.
How much memory on the server. How many desktop 4D Clients? Are you running compiled?
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.
You should try it. At the least it could tell you which process on your server is consuming resources.
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.
Can you describe what the database-intensive reports are doing? When you say "reports are generated", do you mean a web page is returned, a 4D report is printed, or something else?
-- Brad
