Re: Cpu usage of stored procedures

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

Alan,

Thanks. That's certainly one possible approach.

However, we have a number of stored procedures which we've been using
in 4D 2003 and 4D 2004 quite effectively over the years. This is the
first time I've seen 4D Server being significantly slower than 4D
Client for this type of operation. The problem seems to be related to
4D Server v11. Perhaps it's because we're manipulating large string
arrays. If that's the case, I suspect we'd see the same problem in a
trigger.


Paul Smith

TSE International




> While we never used Store Procedure to do such task, we did these
> type of
> task day in and out in Trigger without problem.
>
> We have table named like Task_trigger that contain Blob field and
> task ID,
> we put arrays in the blob and do whatever we like in the trigger -
> updating old data or creates new records on other tables ... etc.
>
> Normally, we split the array into 3,000 at a time to let it update/
> create
> new records in order not to holding down other server operations.
> Starting
> with v11, we split the tasks to a pool of Task_trigger tables.
>
> We have been doing this on 2003 for years without any performance
> problem.
> As we haven't actually deployed v11, we do not know its effect in
> production yet.
>
> Alan Chan

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