Article Details
Id:8803
Product:finPOWER Connect
Type:NEW
Version:1.03.02
Opened:20/05/2011
Closed:20/05/2011
Released:23/05/2011
Job: J007456

Database Optimisation; Account form may unnecessarily make database calls

The Account form may unnecessarily run the following database query twice for every record loaded (depending on the page that is open):

SELECT Count(*) AS [RecordCount] FROM [Branch]

This query is now only run once, when first required, and not every time a record is loaded.