I would like to be able to indicate which tables should be kept in memory in order to improve the performance.
Keep tables in memory
Software Factory
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
For DB2 projects, the property KEEPINMEM will be used when a table has Yes (durable). For more information about this property, see IBM documentation (https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/cl/chglf.htm) For Oracle project, the option CACHE will be used when a table has Yes (durable).
For more information about this option, see Oracle documentation (https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_7002.htm#i2215507)
Check here, for example: https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/transact-sql-constructs-not-supported-by-in-memory-oltp?view=sql-server-2017
It is now possible to keep a table into memory. There are three options: No, Yes (durable) and Yes (transient). The option Yes (transient) is only available for SQL server projects. For more information about memory optimized tables in SQL server..
Can you explain the difference between Yes (durable) and Yes (transient)?
Yes (transient) is only stored in memory, so if the server crashes you loose your data. While with durable, the data is stored and will be loaded in memory again. You can use transient for example, when the data is calculated based on other tables.