K2View Customized Rules
4.5 LU and Tables
1. To validate that a record exists - don't use count()
-To validate that a record exists, select the first row with the required ‘where’ condition (using limit 1 or rownum < 2 – depends on the DB). Do not use count(* * ) in the query as this is time
consuming.
2.Table Population on top of the LUDB
-Do not set it to automatically run every second. This population should be executed only when the source tables are being updated and therefore in most cases should be based on decision function.
K2View Customized Rules
4.5 LU and Tables
1. To validate that a record exists - don't use count()
-To validate that a record exists, select the first row with the required ‘where’ condition (using limit 1 or rownum < 2 – depends on the DB). Do not use count(* * ) in the query as this is time
consuming.
2.Table Population on top of the LUDB
-Do not set it to automatically run every second. This population should be executed only when the source tables are being updated and therefore in most cases should be based on decision function.
