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-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 06 August 2009 20:38 To: Axapta-Knowledge-Village@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