Adële on Nostr: Example of economic choice for a #php app : Sometime, on a shared #LAMP environment, ...
Example of economic choice for a #php app :
Sometime, on a shared #LAMP environment, #MySql is a bottleneck.
If data of users don't need to be aggregated (when they belong only to each user and nobody has to get a global vision of them), it could be a good idea to use a personal #sqlite database, even on a server. One db file per user.
I agree, it does not fit to many applications, but, in the described case, it has increased performance.
Sometime, on a shared #LAMP environment, #MySql is a bottleneck.
If data of users don't need to be aggregated (when they belong only to each user and nobody has to get a global vision of them), it could be a good idea to use a personal #sqlite database, even on a server. One db file per user.
I agree, it does not fit to many applications, but, in the described case, it has increased performance.