Re: Cpu usage of stored procedures

Date: 08-02-10
From: Kevin LaTona <4dlist_at_studiosola.com>

Paul,


On Feb 7, 2010, at 11:15 PM, psmith wrote:

> The job runs at night, when there are no clients connected. The
> first five or six nights we ran it, it was faster on the server than
> on the client side. Since last Monday we noticed it had started
> running very slowly, although the code and the number of records
> handled have not changed.


Have you tried rebooting the server to see if it speeds up again first
run out afterwards or so?

Maybe 4D's internal scheduler is up to something given that it's a
stored procedure.

Not sure if or why but It's a wild guess, may be worth verifying the
idea.

What Mac OS version are you running?


-Kevin




**********************************************************************
The New 4D Partner Program - All the tools you need to be a successful 4D Developer.
Sign up Now: http://www.4d.com/community/partner/registration.html


4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4D_Tech-Unsubscribe_at_lists.4D.com
**********************************************************************