Because of the number of table scans and table sorts in the TPC-H workload, prefetching data from disks into memory is important for optimal performance.
因为TPC - H工作负载中表扫描和表排序的数量较多,所以为获得最佳性能将数据从磁盘预取到内存是很重要的。
This helps ensure the data for this table is continuously cached in memory.
这有助于确保此表中的数据连续地缓存在内存中。
Instead, use an in memory hash table to cache the data and just keep a key to the data in the session.
相反地,应该使用内存中的哈希表来缓存数据,并且在会话中保存一个对此数据进行引用的键。
This allows the entire lookup table to be loaded into memory each time a user submits a request to read or write data.
在用户每次提交一个读写数据的请求时,这可以将要查询的整个表装入内存中。
If the sorted data cannot fit entirely into the sort heap, which is a block of memory that is allocated each time a sort is performed, it overflows into a temporary table owned by the database.
如果无法将排序的数据整个放入排序堆中(排序堆是每次执行排序时分配的一块内存),它就会溢出到该数据库所有的临时表中。
The snippet processor reads table data from the disk array into memory.
snippet处理器将表数据从硬盘阵列读取到内存中。
This is because Oracle uses a lot of virtual memory, particularly with respect to its System Global Area (SGA), which is used to cache table data, among other things.
这是因为Oracle使用大量的虚拟内存,特别是对于其系统全局区域(SGA),这个区域用于缓存表数据和其他东西。
HSQLDB keeps all table and index data in memory, saving all SQL statements issued into a file named database.script, which also ACTS as the transaction log.
HSQLDB将所有表和索引数据放在内存中,将所有发出的sql语句保存到一个名为database .script的文件中,该文件同时也充当着事务日志的角色。
Why does a hash table take up more memory than other data-structures?
为什么一个哈希表也需要更多的内存比其他的数据结构?
Though it load data directly from database, as you keep scrolling down it loads more and more data in table and hence the memory usage keep on increasing.
虽然负荷数据直接从数据库,当你继续向下滚动它加载更多的数据表,因此内存使用量不断增加。
Memory data are stored in table set, and data index is set up by hash table.
采用表集的方式存储各类内存数据,通过哈希表建立数据索引。
In this case, CLR has a dedicated data structure called Card Table to record whether the application writes the memory of generation 1 or 2.
针对这种情况,CLR有专门的数据结构(Cardtable)来标志应用程序是否曾经写第1代或者第2代的内存。
Every can the data type of TOAST states for the field of this data type a default is politic, but the memory strategy of the field of specific watch can be revised with ALTER TABLE SET STORAGE.
每个可以TOAST的数据类型都为该数据类型的字段声明一个缺省策略,但是特定表的字段的存储策略可以用ALTERTABLESETSTORAGE修改。
Every can the data type of TOAST states for the field of this data type a default is politic, but the memory strategy of the field of specific watch can be revised with ALTER TABLE SET STORAGE.
每个可以TOAST的数据类型都为该数据类型的字段声明一个缺省策略,但是特定表的字段的存储策略可以用ALTERTABLESETSTORAGE修改。
应用推荐