Welcome to MSDN Blogs Sign in | Join | Help

News

  • The views expressed in this blog are those of the individual and do not necessarily represent those of Microsoft. This information is provided by way of general information only and should not be relied on without obtaining independent expert advice. These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use
How to Change BCM Polling Interval?

This post explains how one can change the polling interval in BCM. Please note that this is suggested only for advanced users and for the environment where BCM is used in shared mode.

What is Polling Interval?

When BCM is used in shared environment, all BCM clients poll the server machine to see if there are any changes to BCM data. This allows BCM client to display the most up-to-date data. By default, BCM clients polls server every second in order to ensure that any changes to data made by any client are available to all the clients immediately. Although a short polling interval is desirable so that new data are immediately available, server and client machines pay the cost of frequent polling. In certain BCM usage scenarios (for example, many clients are connected to server), you might get improved performance if polling interval is set higher than default of one second. If the polling interval is set too high, clients will process the changes less frequently but they will have to process more changes at a time. So, you might have to experiment with different values and set the one that works for

How to Change Polling Interval?

In BCM SP1, we have added a registry key that you can tweak to increase the polling interval.  Make sure to close Outlook with BCM before changing the registry key value.

The setting is controlled by “HKCU\Software\Microsoft\Business Solutions eCRM\PollingInterval” registry key. The key should be a DWORD (32-bit) value, the number represents the interval in milliseconds.  By default this is 1000 (1sec), changing this to some higher value could help reduce the load on the database.  This reg key needs to be added on each BCM client machine. We don't have any recommendation for what value to use because every user's requirements might be different (For example, one might prefer getting updates more frequently than system overhead). But you could try out with 30 seconds and see if you notice any difference. By default "PollingInterval" key value might not exist. First create a DWORD key in “HKCU\Software\Microsoft\Business Solutions eCRM” and then set its value.

I hope it helps answer some of the comments about polling interval.

-Mukesh

Posted: Wednesday, January 23, 2008 6:30 PM by bcmteam

Comments

David Overton's Blog said:

I was hunting for an answer to a questions someone asked me and I came across this the BCM Team Blog

# February 13, 2008 1:59 AM

Pawel_ said:

Could you explain the difference between pooling interval and synchronization time (in offline settings)?

# June 30, 2008 12:02 PM

bcmteam said:

Polling interval is for sharing scenarios:

when connected to the shared db, the client queries the shared db every polling interval to get the latest updates;

synchronization interval:

is when the client goes offline due to connection is lost, the client uses it to ping the server every sync. Interval to see if it can go back online.

Thanks

Vinit[MSFT]

# June 30, 2008 3:06 PM

wigital said:

To correctly understand the DWORD value...

Should it be

"Hexidecimal"

OR

"Decimal"

The post does not specify ???

For a 1 to 1 equivalent in milliseconds I believe it should be "Decimal". Is this correct?

Thanks

# August 13, 2008 10:31 AM

wigital said:

About Integration and Office Accounting TABLES/FIELDS

I have BCM and Microsoft Office Accounting integrated on a Domain. SQL Server 2005 Standard is the database and is hosted on a dedicated Database server.

I'm experimenting with adding "Employees", altering "Employees" etc... (which is an Accounting field). Accounting tables are integrated with BCM (after integration) so it's the same database now.

RE: Accounting specific FIELDS... I'm finding that under certain circumstances "in regard to certain Accounting FIELDS", the refresh of data does not propogate to other machines on the network (other Clients) "quickly or at all". This occurs regardless of the polling interval set.

If I close and then re-open Microsoft Office Accounting on "other Client Machines", whatever changes have been made then appear on the other Clients. (example: adjustements I've made to my Employees then propogate). This "latency" is true of some, but not all accounting FIELDS. Invoices appear immediately as and example but certain other fields (such as Employee Job Position) do not.

This makes no sense to me because all clients are pulling from the same database with BCM and Accounting integrated.

I'm still finding out what fields this is TRUE of so I can't provide you a list yet.

QUESTION:

Does the REGISTRY KEY "PollingInterval" apply to the database as a whole (after intergration)? - - OR - - does it apply to certain tables and fields specifically? "Some" Accounting FIELDS are not responding to the BCM PollingInterval setting described here.

TO REPLICATE THIS

* logon to a client machine using the Owner or Manager role

* add three employees

* give them a Job Position (Salesperson)

* open BCM and Accounting on other clients on the network

*create a Time Entry on client machine #2 (you'll view the Employees and Job Positions)

* choose Employee and save

* go back to the Owner/Manager machine #1

* change the Job Positions for each of the Employees (from Salesperson to Consultant)

* go to Client machine #2 and open the Time Entry you created earlier

* YOU WILL NOTE THAT THE JOB POSITION CHANGE YOU JUST MADE ON THE OWNER/MANAGER MACHINE IS NOT REFLECTED ON THE OTHER CLIENT (REGARDLESS OF POLLING INTEVAL)

+++(at least this is currently true on my network)+++

* on Client Machine #2: close and re-open Microsoft Office Accounting

* the changes are now pulled from the database and the updated Job Positions are in the Time Entry drop downs

Thanks much for the assitance

# August 13, 2008 12:17 PM

bcmteam said:

Hi wigital

It is how you input the data.If you want to type “1000” for 1 second, you should input with decimal format.

Thanks

Vinit [MSFT]

# August 14, 2008 1:59 PM
Anonymous comments are disabled
Page view tracker