Hi Rajesh, For sure I would take a serious look at how long the balance/aging reports are likely to take!!!!
Also I cannot recall in the standard the CustTable is set as cache ALL?? If so I think you better turn it off otherwise each users first access to CustTable after they have logged in will take some time to get all the records off the server and cached onto the client (not sure if you are using 2 tier or 3 tier..) Are these really 1.5 million active customers? What kind of business is this? -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Sent: 30 January 2007 07:54 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Customer Master Hi All, I am just about to implement V3.0 (SQL d/b) on a client, who has a customer master of 1.3 million records. . . . Does anyone have any experience with this size of customer master table, and are there any known issues that one needs to be aware/mindful of. Appreciate any feedback. Cheers. Rajesh Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links