Reducing Latency and Managing Data with an Asynchronous Approach

In the previous chapter, we created a new Laravel Octane application, and we applied some features provided by Laravel Octane to improve performance and reduce the response time of our application.

In this chapter, we will try to optimize more things, such as access to a database and changing and improving the caching strategy. To improve and make queries to data faster, we will explain the benefit that comes from indexing columns. For caching, we will also take a look at a cache-only approach.

For example, in the previous chapter, we executed queries in parallel. Now, we will optimize a query because parallelizing something fast is better than parallelizing something slower. Query optimization allows code to retrieve data from databases faster, reducing the latency that normally occurs when reading data from any source (a file, database, or network).

Then, we will show how to make the query process faster using...