To Joakim about speed of first query.

[Ruslan Zasukhin]

On 26/4/07 1:36 AM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>> 1) I want compare on mac intel
>> 
>> 2) may be this is result of defragmentation of index pages
>> 
>>     * we can try write that DEFRAGMENT also work for index files.
>>         and see if this helps.
>> 
>> 3) we can try implement some prediction-algorithms to
>> pre-load index pages into cache ... Here also not 5 minutes,
>> because it needs count for case of big db and index not fit
>> cache size...
>> 
> 
> Take your time looking at it to conclude what it best or find exact reason
> etc. I find it strange though this takes place efter every reboot but I can
> only speculate of possible reasons for this, so I wont :-)

I have told you why -- because Windows LOAD from disk to system virtual
memory

Only here is difference.


> I assume you used 2.5.9 profiling or 3.0?

3.0  this do not matter

> If you think 3.0 production is not
> too far in future I can switch over to take part in beta testing and aim for
> using 3.0 in my final.

Yes this will be good idea.

> That would probably make it more useful for you,
> profiling with 3.0, due several different problems my final is delayed
> anyway and will probably still take 2-3 weeks at least.
> 
> Anyway, thanks for looking at this.

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