View Issue Details

IDProjectCategoryView StatusLast Update
0000059ScriptBaseFeaturespublic2018-11-18 14:44
Reporterrichp10Assigned Torichp10 
Status resolvedResolutionfixed 
Product Version4.14 
Target Version4.15Fixed in Version4.15 
Summary0000059: Move lookup tables to memory tables for big performance gains
DescriptionScriptBase uses quite a lot of lookup tables. When loading a prescription, these lookup tables are used to populate with meta data such as pharmacy, drugs and prescribers. This generates a lot of data requests and on the client server version this was killing performance.
Additional InformationAll lookup tables are now copied to memory on the client machine at startup. These are used for all tasks for the duration of the session.

The performance gains are massive - with most tasks now being ten times faster.

Main implication is that users need to understand that changes to lookup data on a network will not be 'visible' to other users until they restart.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-11-18 14:44 richp10 New Issue
2018-11-18 14:44 richp10 Status new => assigned
2018-11-18 14:44 richp10 Assigned To => richp10
2018-11-18 14:44 richp10 Status assigned => resolved
2018-11-18 14:44 richp10 Resolution open => fixed
2018-11-18 14:44 richp10 Fixed in Version => 4.15