We had already disabled Audting also we disable UnitOfWork(isTransactional: false) for speed up query execution.
Indeed there is some improvement about 100ms but still. Request take 300-400ms and query execution is only 160ms, Where to look for another improvements? And to solve the problem with token the solution is to change configuration of expiration time?
Line 486: INFO [2020-05-14 15:09:26.4566] Microsoft.AspNetCore.Hosting.Diagnostics |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Request starting HTTP/1.1 GET https://OurProjectDomain/api/services/app/Course/GetAll?Sorting=&SkipCount=0&MaxResultCount=10&Keyword=&Filters= application/json
Line 487: INFO [2020-05-14 15:09:26.4566] Microsoft.AspNetCore.Hosting.Diagnostics |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Request starting HTTP/1.1 GET https://OurProjectDomain/api/services/app/Course/GetAll?Sorting=&SkipCount=0&MaxResultCount=10&Keyword=&Filters= application/json
Line 488: INFO [2020-05-14 15:09:26.4695] Microsoft.AspNetCore.Cors.Infrastructure.CorsService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll CORS policy execution successful.
Line 489: INFO [2020-05-14 15:09:26.4695] Microsoft.AspNetCore.Cors.Infrastructure.CorsService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll CORS policy execution successful.
Line 490: INFO [2020-05-14 15:09:26.5196] Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Successfully validated the token.
Line 491: INFO [2020-05-14 15:09:26.5298] Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Successfully validated the token.
Line 492: INFO [2020-05-14 15:09:26.5298] Microsoft.AspNetCore.Routing.EndpointMiddleware |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executing endpoint 'OurProject.Business.ReservationsSystem.Courses.CourseAppService.GetAll (OurProject.Application)'
Line 493: INFO [2020-05-14 15:09:26.5298] Microsoft.AspNetCore.Routing.EndpointMiddleware |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executing endpoint 'OurProject.Business.ReservationsSystem.Courses.CourseAppService.GetAll (OurProject.Application)'
Line 494: INFO [2020-05-14 15:09:26.5479] Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Route matched with {area = "app", action = "GetAll", controller = "Course"}. Executing controller action with signature System.Threading.Tasks.Task1[Abp.Application.Services.Dto.PagedResultDto1[OurProject.Business.ReservationsSystem.Courses.Dto.CourseDto]] GetAll(OurProject.Generics.PagedAndSortedWithKeywordAndFiltersResultRequestDto) on controller OurProject.Business.ReservationsSystem.Courses.CourseAppService (OurProject.Application).
Line 495: INFO [2020-05-14 15:09:26.5479] Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Route matched with {area = "app", action = "GetAll", controller = "Course"}. Executing controller action with signature System.Threading.Tasks.Task1[Abp.Application.Services.Dto.PagedResultDto1[OurProject.Business.ReservationsSystem.Courses.Dto.CourseDto]] GetAll(OurProject.Generics.PagedAndSortedWithKeywordAndFiltersResultRequestDto) on controller OurProject.Business.ReservationsSystem.Courses.CourseAppService (OurProject.Application).
Line 496: DEBUG [2020-05-14 15:09:26.5794] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll START GetAll for CourseDto
Line 497: DEBUG [2020-05-14 15:09:26.5895] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll START CheckGetAllPermission
Line 498: DEBUG [2020-05-14 15:09:26.5895] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END CheckGetAllPermission and START _queryService.GetAll()
Line 499: DEBUG [2020-05-14 15:09:26.5895] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END _queryService.GetAll() and START ApplySorting(query, input)
Line 500: DEBUG [2020-05-14 15:09:26.6100] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END ApplySorting(query, input) and START ApplyKeywordSearch(query, input)
Line 501: DEBUG [2020-05-14 15:09:26.6100] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END ApplyKeywordSearch(query, input) and START ApplyFiltering(query, input)
Line 502: DEBUG [2020-05-14 15:09:26.6254] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END ApplyFiltering(query, input) and START query.CountAsync();
Line 503: DEBUG [2020-05-14 15:09:26.6552] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END query.CountAsync() and START ApplyPaging(query, input)
Line 504: DEBUG [2020-05-14 15:09:26.6552] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END ApplyPaging(query, input) and START page.ToListAsync()
Line 505: DEBUG [2020-05-14 15:09:26.7402] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END page.ToListAsync()
Line 506: DEBUG [2020-05-14 15:09:26.7469] OurProject.Business.ReservationsSystem.Courses.CourseAppService |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll END GetAll for CourseDto Execution Time: 00:00:00.1573364
Line 507: INFO [2020-05-14 15:09:26.7641] Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executing ObjectResult, writing value of type 'Abp.Web.Models.AjaxResponse'.
Line 508: INFO [2020-05-14 15:09:26.7641] Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executing ObjectResult, writing value of type 'Abp.Web.Models.AjaxResponse'.
Line 509: INFO [2020-05-14 15:09:26.7641] Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executed action OurProject.Business.ReservationsSystem.Courses.CourseAppService.GetAll (OurProject.Application) in 216.5482ms
Line 510: INFO [2020-05-14 15:09:26.7776] Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executed action OurProject.Business.ReservationsSystem.Courses.CourseAppService.GetAll (OurProject.Application) in 216.5482ms
Line 511: INFO [2020-05-14 15:09:26.7776] Microsoft.AspNetCore.Routing.EndpointMiddleware |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executed endpoint 'OurProject.Business.ReservationsSystem.Courses.CourseAppService.GetAll (OurProject.Application)'
Line 512: INFO [2020-05-14 15:09:26.7776] Microsoft.AspNetCore.Routing.EndpointMiddleware |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Executed endpoint 'OurProject.Business.ReservationsSystem.Courses.CourseAppService.GetAll (OurProject.Application)'
Line 513: INFO [2020-05-14 15:09:26.7932] Microsoft.AspNetCore.Hosting.Diagnostics |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Request finished in 336.5918ms 200 application/json; charset=utf-8
Line 514: INFO [2020-05-14 15:09:26.7932] Microsoft.AspNetCore.Hosting.Diagnostics |365392c0-40c9de129d8ebb4d. GET https://OurProjectDomain/api/services/app/Course/GetAll Request finished in 336.5918ms 200 application/json; charset=utf-8
I check table AbpUserTokens 892 records , 8 was expired I delete them but still issue is there. Can I delete all this records?
