We are looking for an experienced Django and Python professional to improve the performance of our project's web pages and evaluate and fix the initial Django setup. The ideal candidate will have an understanding of web development principles and performance optimization techniques. You will be responsible for diagnosing performance bottlenecks and implementing solutions to improve load times. To achieve this goal, we have structured the project around the following points: Improve the reports’ page load: • Check and optimize the construction of queries. • If it exists, remove queries within the loop and sub-queries, so that a query is created before the loop and saved in the application cache to use specific values, concatenating them at the time with the corresponding line. • Below is a preview of the reports that you should change, specifically with their respective execution times. We need to improve these times to reach 2 to 3 seconds of total loading, at most. Reports: VISÃO POR EMPRESA E PACOTE ----------- - Route: /api/report/load-indicator-company-and-package-view - Load total time: 52s - Query time: 30s - % DB time: 58% Materiais e Serviços por Classe Custo ----------- - Route: /api/report/material-services-cost-class - Load total time: 17s - Query time: 11s - % DB time: 65% Create caching and make asynchronous calls: Implement filter caching and preload some lists by making asynchronous calls. For example, when the user chooses an option from the Companies list, an asynchronous request can load the Budgets immediately after. This way, when the user opens the options list, this information will already be in the cache, responding more quickly to navigation. The filter item cache can be configured with an approximate time of 1 minute. Replacing insects within loop: Evaluate and implement the Bulk Operation functionality for pages that import spreadsheets, as the number of rows can be quite large, improving the efficiency of the insertion process in the database. If you are passionate about delivering fast and efficient web applications, we want to hear from you!
#J-18808-Ljbffr