Quick Tips - Things i learned while in a Financial Project

[Vinayak Belgaon]

As a developer i learned few things while i was working on an Financial Project for ITBM/ITFM project

• Dont create fields with type currency unless if it actually necessary, instead use decimal type field. Creating a field type as currency will have an instance of it created in fx_currency_instance table. Hence inserting or updating a record will also update the fx_currency_instance table every time which will make the query run slow.
• If the number of records is more, test your encoded query for execution time using the Fix script and checking the progress worker. Use the Script Action to call some recurring scripts if required.
• Do not write larger action in a while loop of a glide record instead run a for loop by taking the sys_id of the records in an array by using getValue(sys_id.toString() will compareably take more time)
• Error Handling plays a major part in running efficient script. Make sure to throw exception whenever necessary.
• If using scripts in flow designer, write you scripts in script include and call the function in script desinger so that you dont have to republish the Flow
• Always increase the field length of the Import tables created for transforming data