Re: Cpu usage of stored procedures

Date: 09-02-10
From: "Alan Chan" <alan_at_belhk.com>

Hi Paul,

It's possible. During our test on our converted application and one test
data, we run our update method to convert data in 3 tables totalled 1.5M
records. All are done in triggers. I need to point out that, in this
particular method in v11, we only used Longint array for table
number/field number and no string/text array was involved. No conclusive
answer for "possible string array issue".

Although we did some testing on importing data (same trigger methodology)
that contains string/text array, it only involved small import data set
(few thousand records). That particular test was for unicode capability
for mixed data (mixture of Chinese, Japanese and English) and not for
performance. Sorry for non-answer.

Alan Chan

4D iNug Technical <4d_tech_at_lists.4D.com> writes:
>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.

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