Does BCM2 have a limit of 10k records?

  • Thread starter Thread starter Ed Marmon
  • Start date Start date
E

Ed Marmon

I saw another forum post elsewhere pooh-poohing bcm because of a 10k record
limit. Is this true? I there in fact any arbitrary maximum number or is it
limited by the machine you're on?

thanks
 
There is no such limit.

You are limited by your machine and network latency: when database
tables get too large and it takes more than 1 minute to return a query,
the connection will time out.

You are limited by database connections: MSDE has a limit of 5
concurrent connections running in the database. Later requests get
queued up. You'll notice a slow down if say several users
simultaneously run reports from BCM or do imports.

You are limited by absolute amount of data: MSDE has a limit on
database size (2 GBytes?). How many records you can have before you run
into this limitation depends on your entity ratios (e.g. number of
Activities to Accounts) and how much data is in each record.

These last two aren't strictly BCM limits, but a SQL Server licensing
issue. MSDE is free. If you buy a SQL Server license the issues go
away. With a license the server can also use more CPUs, so issue 1 is
also mitigated.

In my experience, with a typical small business PC's RAM and CPU, with
a typical mix of processes and services running on the machine, the
first limitation is the one you'll run into.
 
You are limited by absolute amount of data: MSDE has a limit on
database size (2 GBytes?). How many records you can have before you run
into this limitation depends on your entity ratios (e.g. number of
Activities to Accounts) and how much data is in each record.
Click to expand...

1. thought is was 4 GB, but maybe it's a hope more than a recollection. if
you say it's 2 then it's 2.

2. one can help the second part of your above point by using the archiving
feature to reduce older space-filling history, attachment and other items,
no?
 
I believe Outlook archiving pertains to the data stored by Outlook in
its PST file.

For the BCM data you'll have to back-up the database and then manually
purge the older history items yourself--delete them and then delete
them again from the BCM deleted items folder.
 
I believe Outlook archiving pertains to the data stored by Outlook in
its PST file.

For the BCM data you'll have to back-up the database and then manually
purge the older history items yourself--delete them and then delete
them again from the BCM deleted items folder.
Click to expand...

I see what you're saying. Have you an idea why it would nevertheless offer
to archive items specifically from the various BCM folders anyway?

I hesitate to do it- but does anyone know if I do go ahead and archive
business items will it-

1. give an error since its trying to archive BCM items to a .pst?
2. do it?
3. do it by converting the business items to outlook.pst-friendly items? (
just like outlook items can be dragged to create BCM-friendly items )
4. else?

Again, Im refering to the archiving command which seems to be available for
business contact items...
 
It gives an error.

I think Outlook blindly shows all MAPI stores in the Archive dialog,
irrespective of whether the store supports archiving to PST or not.
 
It gives an error.

I think Outlook blindly shows all MAPI stores in the Archive dialog,
irrespective of whether the store supports archiving to PST or not.
Click to expand...

Nuts. Another interesting design idea. BCM is toughted as the most
intergrated into outlook. Easy. Intuative. Works the way you're used to...
so... Why not include archiving? That would set it apart...

Thank you for following up, and for your insights on other answers you've
given to me and to others as well.
 
Back
Top