Article Details
Id:12819
Product:finPOWER Connect
Type:FIX
Version:2.03.00
Opened:18/04/2015
Closed:20/04/2015
Released:09/07/2015
Job: J015309

Transaction and Bank Transactions; commit was not properly optimised

The Transaction and Bank Transaction commit was not properly optimised.

Before beginning the actual commit some global collections are refreshed to ensure up-to-date information is used. This includes Entities, Transaction Types and Elements. This means a small database query is run to check if the information is up-to-date, and if not up-to-date a full refresh is run.

Unfortunately, the refresh code for Transaction Types was causing both the Transaction Type and Element collections to be fully refreshed every time - resulting in unnecessary database queries.

In addition, another optimisation has been added so that if the Transaction Type on the batch is not set the Transaction Type collection is not refreshed.