Improving scalability and performance
The preceding example shows a simple application that uses a local SQLite database, and performs all operations on a single machine. However, as the number of clients we need to support grows, our application would need to change part of the approach in order to support a large number of clients.
In most small and medium sized cases it is sufficient to create an application that works on a single system, in some cases it is worth considering how to make our application scale better.
One or more of the following steps can be done to gain better scalability and improve its performance:
Create multiple systems for managing subsets of clients and create an application that works on top of servers, and points clients to the appropriate servers. Clients could initially ask for the actual server to communicate with, and then contact this server. The comm API would then also be handled in a similar case —a single interface could be exposed that would query...
