( szekelyk | 2021. 04. 08., cs – 11:47 )

Szerintem inkább ez a vége. :)

Checklist For Choosing The Right Database Engine

  1. Is the data separated from the application by a network? → choose client/server

    Relational database engines act as bandwidth-reducing data filters. So it is best to keep the database engine and the data on the same physical device so that the high-bandwidth engine-to-disk link does not have to traverse the network, only the lower-bandwidth application-to-engine link.

    But SQLite is built into the application. So if the data is on a separate device from the application, it is required that the higher bandwidth engine-to-disk link be across the network. This works, but it is suboptimal. Hence, it is usually better to select a client/server database engine when the data is on a separate device from the application.

    Nota Bene: In this rule, "application" means the code that issues SQL statements. If the "application" is an application server and if the content resides on the same physical machine as the application server, then SQLite might still be appropriate even though the end user is another network hop away.


Az utolsó bekezdésben említettek alapján a kérdező által írt RDS megoldás a problémára.