[doc] Maximum size for VarChar

[Erik Mueller-Harder]

Ruslan Zasukhin wrote:

>> I have a field that nearly always will have about 150 bytes in
>> it, but sometimes may have as much as 64K; I'm assuming a large
>> VarChar field is the best way to store it?
> 
> I also think so, Just important to see that atomic page now will
> 128KB in RAM.

Hmm.  When exactly does that page exist in RAM -- for how long, I mean?  If I have 100,000 records in a base object and search on that VarChar field (indexed by words), I'm not trying then to use 12.8GB of RAM, am I?  :-O  I would guess not....

I'd imagine the RAM requirement only comes into it when I actually read that method field in explicitly via a cursor (or base object field property), correct?  And, even if I have a cursor with a large number of records, only the current record's field is actually taking up RAM, right?

I don't mind 128K here and there, -- I'm just trying to make sure I don't end up using massive amounts of RAM.

Thanks,

Erik