On Mar 22, 2011, at 6:48 PM, Paul Dalach wrote:
> I am pulling ~80k objects with four fields. Does that constitute huge?
Well, it depends on how big those fields are, doesn't it? If they are four 32 byte
strings, the amount of data in use is at least 10 GB. Pulling that all into RAM at once
on anything less than a 64-bit machine with 12+ GB of RAM means you'd be making the
program run into swap memory very heavily, which will make it very slow.
> If it does, what is the solution?
Do you actually need all of the data in RAM at the same time? If so, buy more RAM and/or
use a 64-bit OS instead of a 32-bit one. If not, try a "use" query instead.