Wednesday, January 23, 2008

BC : Force Active Property

This business component property is more powerfull than most people imagine. Why?
It's simple. If used unnecessary it can decrease application performance.
When you set this property to TRUE, it means that this fiels is queried every time business component is instantiated :

  1. Every time you do a BO.GetBusComp(”Name”) in a script.
  2. Every time you navigate in application and the underlying BC is "Name".
  3. BC is accessed internally in any form.

Why?

Every time you make a field Force active it will be made part of where clause each time a query is issued against that BC or table irrespective of the fact that field is required or not.

You can read detailed information here

1 comment:

Jim Uicker said...

The Column will be selected, but not actually part of the WHERE clause. The real performance hit comes when the Force Active column is on a JOIN table.