NSP code optimizations

In this version optimization functions are included:

•  Optimize writing in DB using GlobalLock

•  Optimize methods with caching

•  Exclude SignalR for translations

•  Optimize writing information in log files if method is recognized

 

Database optimizations

Database optimizing procedure:

•  Optimize SQL queries in DB and added new indexes

•  Store procedure added for fragmentation indexes and statistic SQL

SQL procedure that has to be executed manually:

exec  AzureSQLMaintenance 'all', @LogToTable=1

select * from AzureSQLMaintenanceLog

 

API

The Header has been changed and updated. It is now called Authorization.  This response data need to be kept, and the value of “Token” needs to be put in header “Authorization” with text  Bearer on beginning and space and Token value in other calls. When “Expires” has expired a new authentication for a fresh token need to be made.