A web-based commercial and SBA lending software was developed that manages the origination, processing, closing, and monitoring of small business loan portfolios. With the loan management system, lenders can think big and reimagine what modern business lending can be. It was developed by using Microsoft Visual Studio 2013(.NET 4.5), Bitbucket (Git), ASP.NET MVC, C#, Web API, MS SQL Server 2012, Single Page Application, Kendo UI Controls and Charts, Telerik Reporting, jQuery, Backbone.js, Marionette.js, Require.js, Underscore.js tools and technologies.
Telerik report rendering process was considered too slow.The reason was discovered to be that the ICache caching technique was implemented for Telerik reporting, but the report rendering process was very slow. The Client wanted vteam #397 to analyze the problem and implement its fix, so the overall report rendering process needed to be improved.
During R&D, it was found that Telerik Reporting provides caching mechanism using two techniques:
ICache is a legacy caching approach and it does not support multiple service instances deployment.
IStorage is a preferred storage method by Telerik Reporting over ICache due to its enhanced functionality, allowing the service multiple instance support and specific implementation (MS SQL Server Storage) for MS SQL Server.
IStorage approach requires extra tables (if database approach is used) and a locking mechanism is provided which guarantees the serialized state access.
|IStorage is specifically designed/developed mechanism for SQL SERVER (tweaks and optimizations specific to SQL SERVER).||ICache is a generic solution for all DataBase providers so IStorage performs better than ICache when back-end is SQL SERVER.|
|IStorage provides better resource locking/utilization mechanism (Multiple tables structure for resource bookmarking and locking).||ICache mechanism uses single table for resource bookmarking.|
|IStorage guarantees multiple instance support.||ICache doesn't guarantee multiple instance support.|
Performance was significantly improved by replacing legacy ICache caching technique with IStorage caching technique which is preferred by Telerik Reporting due to its specific implementation for MS SQL Server as mentioned above.
This solution improved the performance of Telerik report rendering process as well as provided support for multiple service instances deployment.