Re: Cpu usage of stored procedures

Date: 08-02-10
From: psmith <psmith_at_tseint.com>

Josh,

It's a big database: > 8 gb. We compacted it, reindexed and verified
it. All amazingly fast on this high-end xServe with SDD drive. Still,
that didn't change anything.

If we execute the exact same method from a client machine instead of
on the server, it creates about 300 records a second - in spite of
having the network overhead. When run on the server, we're only
getting about 8 records a second - in spite of no network overhead.

This seems to be some sort priority/scheduling thing with 4D Server.
We're only seeing the process get around 0.5% of the cpu when executed
on the server. If I run the same method from the client side, it gets
about 8% of 4D Server's cpu.


Paul Smith

TSE International


> Given that a server restart had no effect:
>
> It would be interesting to see if compacting the database would
> affect the performance.
>
> Also check to make sure the indexes are not damaged/missing.
>
> -Josh

**********************************************************************
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
**********************************************************************