Rajesh,
Along the lines Stef has stated you could setup all your active customers as Axapta customers and the rest as CRM relations. This way as non-active CRM relations become active you can convert them to being a customer. Also be aware of contact details these are stored in a separate ContactPerson table. Database logging will also impact performance so be careful. Likewise, if you need more specific input, let me know. Regards Cameron Robinson ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Capiau Sent: Tuesday, 30 January 2007 8:06 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Customer Master Hi Rajesh, I'm working on an implementatation with currently over 4 million customers (and over 10 million crm relations). we are working on 3.0 SP2 with KR2 on an SQL2005 environment. If all data belongs to one company, you should be considering removing the dataareaid as first keyfield in the indexes (you can do this with settings on the AOS). It is also advisable to let sql decide which indexes to use. Be aware when you are using Record Level Permission functionality. This can give strange instructions towards SQL server. If you need more input on specific issues, please let me know. Regards, Stef --- In Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> , "Rajesh" <[EMAIL PROTECTED]> wrote: > > 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 > In operation for more than a century, The Perth Mint is the proud winner of six Marketing and Design Excellence Awards in recognition of continued innovation and minting excellence. With a treasure trove of unique attractions housed on its heritage site in East Perth, The Perth Mint is a multi-award winning tourist destination, winning gold at the 2006 Western Australian Tourism Awards. **************************************************************************** This email, together with any attachments, is intended for the addressee only. It may contain confidential or privileged information. If you are not the intended recipient of this email, please notify the sender, delete the email and attachments from your system and destroy any copies you may have taken of the email and its attachments. Duplication or further distribution by hardcopy, by electronic means or verbally is not permitted without permission. While every care has been taken, The Perth Mint cannot be held responsible for any statistic, statement or representation made in this email. The Perth Mint cannot accept liability for any loss suffered as a result of any action of any kind whatsoever taken by any person based on information in this email. **************************************************************************** [Non-text portions of this message have been removed]