first of all, do i need to cache storage data that is owned by the server? i mean the data that the owner id is “” on the storage engine?
Many configurations are stored on the server that way. if they need to be queried as a part of big database besides the user’s data, I probably have to cache it on the memory to have much better performance,
@virtouso the data is not automatically cached, custom caching may make sense in some specific use-cases, but generally you shouldn’t need it.
All the server storage APIs are carefully designed to make use of database indices and perform as best as they can.
Your client and server code should be written so that it minimizes requests (always batch reads and writes when possible) and makes uses of the runtime APIs sensibly.
Evidently, good performance of the db in a production environment assumes correct setup and sufficient hardware capacity to handle the workload.
Best.