- Practical limit to number of CRM contacts?
- Posted by Ken McDermott on September 26th, 2003
Is there a practical limit to the number of contacts in CRM? I'm looking at
about 1.8 million and can't find anything in the online info.
Thanks
- Posted by Gary on September 26th, 2003
The only limit I can think of is the hardrive space on your SQL
server.......
-Gary
"Ken McDermott" <kenmcd@kmcd.com> wrote in message
news:ejBtGv8gDHA.4088@tk2msftngp13.phx.gbl...
- Posted by dh on September 26th, 2003
There might be a terabyte limit on a table in SQL server. With 1.8 million
contacts you may need to do some of your own indexes for performance.
"Ken McDermott" <kenmcd@kmcd.com> wrote in message
news:ejBtGv8gDHA.4088@tk2msftngp13.phx.gbl...
- Posted by Alan Whitehouse on September 26th, 2003
We had a prospect who was going to have over 500,000 contact records and we
got Microsoft to do some basic testing (not perfect but gave us an idea if
we were going to potentially have problems) and it seemed to function fine
doing lookups on that dataset with no concerns about delays. Can't say for
sure how much more 1.8 million will affect things.
Alan
"Ken McDermott" <kenmcd@kmcd.com> wrote in message
news:ejBtGv8gDHA.4088@tk2msftngp13.phx.gbl...
- Posted by John O'Donnell on September 27th, 2003
Only limits may be the crystal reporting engine. I have heard reports that
the crystal tools do not like very large datasets. As Gary says, SQL server
will not get in the way as long as you have good server hardware etc
"Alan Whitehouse" <awhitehouse@tgo.ca> wrote in message
news:u5cVc6FhDHA.3104@TK2MSFTNGP11.phx.gbl...
