Multiprocessing as a Way to Optimize Queries

Abstract

Developing an effective web application involves the use of various methods and techniques to ensure fast and efficient processing of requests. Sometimes it is not possible to solve the problem of multiprocessing with a single tool, such as a programming language or framework. This work investigates the use of asynchronous methods of processing requests using queues. Job operation in background and non-background modes relative to the main web process is studied. Analytics are provided to analyze a web application with 13,000 requests to process daily. It is proposed to optimize the processing by using the Laravel framework and the Python server dual-tasking using the Supervisor tool on Linux, as well as using a task scheduler for each task. The paper presents positive findings about this algorithm, which contributes to the efficiency of web development and provides a great user experience on the website. Fast processing of web application requests can be a valuable competitive advantage for a business or organization. Research in this field helps to maintain their high competitiveness. In addition, the study of query processing speed is important in scientific research, as it contributes to the development of new algorithms, optimization methods and technologies.