Azure SQL and perfomance
Posted: Wed Oct 15, 2025 12:50 pm
Our application is built in the blazer server environment. The reports are created in the StimulSoft Report environment and work smoothly in combination with a local IIS setup. The problem arises when we transfer the solution within the azure app service to the azure sql database. Then the report that was working, let's say 20 seconds now requires several minutes. The application service and the database are located in the same region and verified, the response to the query from the application for the same data is almost identical compared to the local server. What could be done to speed up the reporting process, considering that during the creation of the report I get a question twice if I want to give up the activity because it is taking too long. The query itself is simple, but there are a lot of pages in the result, about 150.