Hi absi The planned order creation, is it while running complete master plan or creating a record from the form?
How many companies do u have? Have u checked for fragmentation of the database? What is the run time of the planned production order? i.e. the order is supposed to be scheduled for how many days? If u create a similar order from production then how much time does it take to schedule it? How many master plans do you have for a single company? Regards Harry This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm" The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of abdulabsi Sent: 14 December 2005 09:58 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Urgent-Slow Creation of planned production Order-master Planning Dear All, I am facing a huge delay around 40-45mins to create one planned production order form the MasterPlanning module. We are running Axapta 3.0 AOS under 2003 plateform and ORacle 9i DB.the size of the DB is 25G. Planned Order form is trying to add some new records in three huge Tables Reqtrans with alsot 2Million records ReqPo with alomost 2 Million records RweqTrabnsCov with alosmt 1,4 million records. I tried to optimize the DB and rebuild the indexes more than one time but with no huge difference. I had some doubt in the AOS and I tried to create the Planned Order usign the 2-tier but still I am facing the same delay Is there any way to optmize the DB or the Application PLease Advise ASAP Thanks Absi Sharing the knowledge on Axapta. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> $15 provides a child with safe, clean water. Your gift can make a difference. http://us.click.yahoo.com/vp8GxB/icGMAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/