The basic actions performed in each database transaction are as follows:
The request reaches the database server via the network.
The database server processes the query in the query plan.
Now the database server executes the processed query.
Again, the database server returns the result to the querying application through the network.
At last, the application processes the results.
This process is repeated every time we request a database operation, even if it is for a simple or small query. It is always a costly transaction to hit the database for the same records multiple times. Sometimes, we also face some delay in receiving the results because of network routing issues. There may be some other parameters that affect and contribute to the delay, but network routing...