Question : I am using mariadb 10.4 with nignx with joomla 4 on Debian 8 system. Is it possible for […]
Tag: memory-optimized-tables
Memory-optimized table index size 10X bigger than data
Question : On one of our production servers, I found that index size is 10X times bigger than data size. […]
SQL Server In-Memory Table Conversion [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Efficiently store large list structure in RocksDB so that the data can be retrieved in pages
Question : Description: RocksDB is a key-value storage so we can simply serialise the list of objects & store the […]
Defining OLAP or OLTP on table level in Oracle/postgres/SQLserver
Question : Usually companies have separate databases for OLTP and OLAP (Row stores and column stores) where data is loaded […]
Use Natively-Compiled Stored Procedures in disk-based tables
Question : Is it completely worthless to use a Natively-Compiled Stored Procedure over disk-based tables? (SQL Server 2016) Should all […]
Conditions for memory optimized tables stored in off-row data table
Question : Memory optimized tables store LOB types in internal tables. I have a table with no explicit LOB types […]
In Memory OLTP causing OOM Issue in SQL Server even though no data in In Memory OLTP Table
Question : We have only 1 memory optimized table in each database and there are total 10 databases as such. […]
Cons of using a star schema in a columnar database
Question : My organisation is implementing a new data warehouse using a columnar data store (Redshift) and the performance is […]
Adding index – There is insufficient system memory in resource pool ‘default’ to run this query
Question : Here’s the query I’m trying to run in order to add an index to my new memory optimized […]