in reply to
Re: Re: STOP Trading Memory for Speed
in thread STOP Trading Memory for Speed
You didn't read his problem.
The memory limit is not physical memory, it is the fact that you can only address 4 GB with a 32-bit pointer.
BerkeleyDB might solve this by taking less memory. It might also be able to use anonymous paging to work even though it cannot directly address most of that memory. The documentation says that data sets that large usually speed up by switching from hashing to a BTREE.
But letting it swap won't work.