Re: Cpu usage of stored procedures

Date: 09-02-10
From: Arnaud de Montard <arnaud_at_init5.fr>

Le 8 fÈvr. 10 ‡ 16:49, psmith a Ècrit :

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

Did you try to give more stack with Execute on server?
About FLUSH BUFFERS: on 4DBB, some people said that since they have
stopped using this command, data corruptions have stopped too...

--
Arnaud de Montard






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