hungrybread

Journal articles are one place where unknown references are expected and the poster should be citing them in a bibliography, even pop culture or joke references.

The basic idea is to keep data as close to the processor as possible, so with a database that means storing the result of commonly used queries in memory.

• https://aws.amazon.com/caching/
• https://aws.amazon.com/caching/database-caching/

There’s no need to migrate the database, that shouldn’t be an issue at this size. Caching should be implemented as another comment suggested.