Yes this is the property but I cannot remember the different values sorry so you will have to search MSDN etc Also check on the users options setup on the PreLoad whether the Markup trans is ticked (this is per user and the same as having FullTable cache) Just to check does the slow performance happen everytime or just the first time a specific user 'loads' the MarkupTrans? Also it might be that the SQL index is clustered or something (I have yet to fully understand when a clustered index is a good or not good idea but it seems a common advice to check on this and potentially change it - I think there is a setting in AOT for it...) Thanks James
_____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 06 August 2009 22:36 To: Axapta-Knowledge-Village@yahoogroups.com 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- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.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- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com > [mailto:Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com] On Behalf Of edwardjosling > Sent: 06 August 2009 20:38 > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.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 >