How frequently does this process run? I use a bpm async process server to defer updates like that to times when there is less activity in the system.
Sent from my Verizon Wireless 4GLTE Phone
-----Original message-----
From: bw2868bond <bwalker@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wed, Oct 26, 2011 13:05:11 GMT+00:00
Subject: [Vantage] Re: 4GL question
I want the server to do the work and still let other users work....
The code is running in a BPM. Would using UpdateTableBuffer to update the records and still allow users to use Vantage?
I wouldn't mind so much if the server showed all 4 cpu cores pegged to the max, but this BPM barely taxes a single core....
Sent from my Verizon Wireless 4GLTE Phone
-----Original message-----
From: bw2868bond <bwalker@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wed, Oct 26, 2011 13:05:11 GMT+00:00
Subject: [Vantage] Re: 4GL question
I want the server to do the work and still let other users work....
The code is running in a BPM. Would using UpdateTableBuffer to update the records and still allow users to use Vantage?
I wouldn't mind so much if the server showed all 4 cpu cores pegged to the max, but this BPM barely taxes a single core....
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...> wrote:
>
> So you want your server to do a lot of work without affecting the rest of
> the stuff running on said server??? ERM...
>
> The only thing you can do is throw hardware at it... Do it in small batches?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Oct 26, 2011 at 8:12 AM, bw2868bond <bwalker@...>wrote:
>
> > **
> >
> >
> > I have a query that returns 4 - 5 thousand records.
> > I use a for each statement to iterate through them and use an assign
> > statement to set a value.
> >
> > This seems to impact overall Vantage performance while it runs to the point
> > of making vantage unuseable.
> >
> > Is there a way to update the records without impacting Vantage performance
> > so much?
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]