[doc] Maximum size for VarChar

[Ruslan Zasukhin]

on 8/8/03 16:57, Erik Mueller-Harder at lists at praxisworks.com wrote:

> 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....

:) no of course.

This page is inside of Valentina cache.
Potential problem which can be here
-- you read one record from one page
        so 128KB is read from disk
-- you read second record from second page
        another 128KB reads.

IF cache is full you will eat it by 128KB.
This is worse scenario. Do not worry about this.

> 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.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------