Cache

[Ruslan Zasukhin]

On 5/14/05 4:34 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I have found that the database cache needs to be a *lot* larger in V2
> than V1 for the same amount of data. I assume that's because the
> stored information for me (mostly text) is UTF-16.

But then not a lots, but 2 times maximum
 
> My question is, when we get UTF-8 storage, with the cache
> requirements go down? Or will the cache still be populated with
> UTF-16?

Not sure yet, Jon.

It seems pages in cache will be in UTF8,
And when record will be loaded into fields, conversion will be done

 
> Also, on a related note, I've found that in some cases having too
> little cache -> crashes (e.g. 4 MB of cache not being enough for 7000
> records). This never happened in V1.x -- performance just became
> unacceptable. Is this an issue you are aware of? Or do you want
> examples?

Actually 1.x also did crash for VERY VERY small cache.

It was possible to see only if db has many tables/fields.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]