Hi Eddie, As this is a trans table, NotInTTS will be ideal caching mechanism. Optimizing caching alone may not help. Ideal method of optimizing performance is analyzing server trace and DMV of the transaction.
If the delay is because of bad Business Logic, then change the code and if its due bad sql add appropriate indexes. But, as this is time taking process, I suggest u to put a breakpoint in each method(override methods if necessary) and see where exactly is it delaying. During the delay process, run the following Stored Procedures in Sql sp_who sp_who2 this will give u the sql that is running from a long time. Then u add the "where clause columns" as an Index in the Table. This might help. I personally feel that you need to add/ modify indexes. Try this and please let me know, if it worked. Thanks, Mahesh ________________________________ From: edwardjosling <edwardjosl...@hotmail.com> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 6 August, 2009 4:36:00 PM Subject: [Axapta-Knowledge-Village] Re: Slow performance on Misc Charges on Purchase Orders Hi James We use Ax2009. In the table properties I see the CacheLookup value is set to "NotInTTS". Are you refering to this value? --- In Axapta-Knowledge- vill...@yahoogro ups.com, "James Flavell" <djf1...@... > wrote: > > Check if the table is set as Tablecache FULL (meaning all records will be > loaded into the users session when the user first accesses the table). If > it is change it to NONE > > > _____ > > From: Axapta-Knowledge- vill...@yahoogro ups.com > [mailto:Axapta-Knowledge- vill...@yahoogro ups.com] On Behalf Of edwardjosling > Sent: 06 August 2009 20:38 > To: Axapta-Knowledge- vill...@yahoogro ups.com > Subject: [Axapta-Knowledge- Village] Slow performance on Misc Charges on > Purchase Orders > > > > > Hi All > > We are experiencing very slow performance (about 10minutes to load!) when > trying to load misc charges on purchase order header. I have noticed that > the MarkupTrans table contains some 870 000 records (this is due to auto > misc postings on sales order lines). Will this be the cause of the slow > performance and if so how do one go about to improve? > > Regards > Eddie > See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/