There are significant differences in the speed of loading results in the Citators between the legacy application and the new application. I understand that efforts have already been made to optimized the performance of the application; however, further improvements need to be made.

My understanding is that the legacy application has a series of daily SQL jobs setup that prepopulate data within the tools so that the system does not need to make a fresh call to server each time a link to results is selected, which effectively increases the speed of generating the results within the tool.

I would like to setup a similar system within the new application for tools where it take more than 1-2 seconds to generate a result. We can build these SQL jobs out over time, but let's start by focusing on the Citators:

When implementing the above, we should ensure the SQL jobs are applied to all the various levels where results are slow to generate (e.g., links and sub-links) and performance auditing should be performed on entries that have the highest number of results within the tool. No entry should take more 1-2 second to produce a result.

Thanks,

Morgan