Message -
From: kumar gaurav
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Friday, January 06, 2006 9:31 AM
Subject: Re: [Axapta-Knowledge-Village] Re: Performance
hi maverick,
first of all ttscommit shd be called at the last of complete
update becuase it takes
. And table consist of million of records. - Original Message - From: Bayliss, Barry To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, January 03, 2006 4:35 AM Subject: RE: [Axapta-Knowledge-Village] Re:
PerformanceHello Maverick,Without more details
December 2005
9:10 PM
To: Axapta[EMAIL PROTECTED]
Subject: Re: [Axapta-Knowledge-Village] Re: Performance
Hi All,
I am also facing the same problem, I have some code which is
processing thousands of update on the table. There is only one process doing
all the updates. So nothing
, December 22, 2005 6:30
AM
Subject: RE: [Axapta-Knowledge-Village]
Re: Performance
Another thing I want to add just incase it was not taken
into consideration. You should but you OS, data file and log file on seperate
volumes. It is recommended to put the OS on a mirrored volume(2 hard
December 2005 08:19To:
Axapta-Knowledge-Village@yahoogroups.comSubject:
[Axapta-Knowledge-Village] Re: Performance
HI Barry,Are you talking about the sql transaction log,
the commitment control in Axapta ? We have done tests with putting
commitment round the entire process and doing a commit after
Hi Harry,
The process can be summarized as follows :
while select custtable notexist join accountstatement
find balancerecord for customer in accountstament for current period
(current period = blank period)
store balancerecord in oldaccountstatement
calculate
m:
Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Capiau Sent: Wednesday, 21 December 2005 7:19 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Performance Thanks for the reply! We are running this process at night, an
Thanks James,
We have tried fooling around with the caching but no effect.
The process does the following, reading all customers, looking at the
transactions (new table, mixture of financial and logistical data)
making a balance on the transactions and generating an opening
transaction in a
Hi StefanThere are countless ways in which performance may be improved but it depends on your specific situation.If you are selecting records for update in a transaction you will have objects (table, page. Record) locks for the tables within the transaction. It looks like you are
Thanks for the reply!
We are running this process at night, and no other processes are
active at that moment.
The strange thing is that when we divide the process into batches of
a couple of thousand records to process, it doesn't matter which
batch we process first. The first one launched is
of the batch?
Barry.
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Stefan
Capiau
Sent: Wednesday, 21 December 2005 7:19 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Performance
Thanks
You are welcome buddy. hope you reach a solution soon.Stefan Capiau [EMAIL PROTECTED] wrote: Thanks for the reply!We are running this process at night, and no other processes are active at that moment.The strange thing is that when we divide the process into batches of a couple of thousand
12 matches
Mail list logo