Number of Contacts in BCM

[Guest]

Is there any limit to the number of contacts that can be added to Business
Contact Mngr? What about a limit on the size of the database? We are trying
to decide between BCM and other customer resource management software. Thanks
for any information you can give me=0)

 

[Luther]

There is no set limit. It depends on your machine's speed and memory.
If you keep adding Contacts, after a while it takes MSDE too long to
respond BCM and the db connection begins to timeout. It also depends on
complexity of your data; e.g. number of activities and opportunites per
contact.

 

[Guest]

We have over 35k contacts in BCM. Works fine but the only area where it is
slow is for example, when adding contacts to an account from a drop down
list.

Every day searches and saving is fine.

 

[Guest]

Thanks to both of you for your help.

We have over 35k contacts in BCM. Works fine but the only area where it is
slow is for example, when adding contacts to an account from a drop down
list.

Every day searches and saving is fine.

 

[Guest]

Actually, in MSDE, there is a 2GB limit. In the next release, which should
use SQL Express, that limit should increase to 4GB.

 

[Scott]

I have run up against this problem. We have 6000 contacts in BCM. When we
go to Link a Record the list takes over 3 minutes to load... any suggestions
or solutions tto this?

 

[Guest]

We have run into a similar problem Fortunately it is not 3 mins for us, but
rather 55 seconds.

Since SQL databases are reasonably fast, I can only guess that the problem
rests with either the front-end or it is an indexing problem. There are not
much in the way of available specs, such as a database dictionary or entity
relationship diagram. With SQL, you can take a look at the database tables,
views, and stored procedures. Everything seems pretty straight-forward and
nothing appears extravagant. So, this is why I suspect that how the
database/tables interact with the front-end suggests that there might be a
need to optimize some programming code. Again, this is just a guess.

Also, I have tried to optimize the database itself, compressing free space,
cleaning up data, etc. to no avail. However, I do suggest that this be done
if you have SQL.

Larry