[Rajashree]

Hi
I'd like some information about the performance issues when a business monitor is used. What are the advantages and disadvantages of using a business monitor?

[AlejandroBarba]

Hi Rajashree,

The big advantage of the business monitors is that they provide the users the ability to track all the relevant information at a glance and the business monitors can be customized to each user's needs.

Nevertheless, it is going to be hard to give you a straight answer about the performance issues because it depends on a lot of factors as how many business monitors, how many saved queries, how often they are being refreshed, the logic of the saved queries in your business monitors, and so on.

We have not experience performance issues due to business monitors but we do not have that many users and we have noticed that most of them have eventually stopped using the business monitors and prefer to work directly with saved queries.

Hope this is useful,

Alejandro Barba

[cunninghamg]

Hi Rajashree

Business Monitors can be slow when there are many saved queries, some of which can get pretty complex.

Users won't use them if they take ages to appear.

We have Business Monitors with 24 saved queries that populate within a few seconds. To achieve this level of performance we use Agents to build a binary like string where each character in the string is a different parameter (either positive (1) or negative (0)). This string is updated on each Order during every modification. The saved queries for the BMs just look at the string rather than running complex saved queries.
So the string might look like 10010110.
You might need Position 1, 4 and 6 to be true.
So the query would look like Select order_base_gid from ob_order_base where <Field> like '1__1_1%'
Note the '_' and '%' are wildcard characters.

PS. This also makes exporting the data easier (Possible) for complex queries.

Hope this helps
Gary