MrSpaceboy
Programmer
Hi, I have a mapping that loads about 2.5 million records.
The problem is the cache. I have 2 very large caches. The index caches are actually the biggest, and both of these are around 600MB.
I can't set the cache size to 600MB or it bombs with "out of virtual memory".
While I run the mappings, I notice that it seems that no matter what size I make the cache -- the same amount writes to disk.
This is making me wonder -- is the cache and "all or nothing" thing? In other words, if the whole cache does not fit in the allocated memory -- the entire file gets written to disk?
I'm open to suggestions or thoughts. Thanks in advance.
The problem is the cache. I have 2 very large caches. The index caches are actually the biggest, and both of these are around 600MB.
I can't set the cache size to 600MB or it bombs with "out of virtual memory".
While I run the mappings, I notice that it seems that no matter what size I make the cache -- the same amount writes to disk.
This is making me wonder -- is the cache and "all or nothing" thing? In other words, if the whole cache does not fit in the allocated memory -- the entire file gets written to disk?
I'm open to suggestions or thoughts. Thanks in advance.