Opening time after startup of Windows

[Ruslan Zasukhin]

On 1/10/09 10:19 PM, "Leo Van den Brande" <leo_van_den_brande at wxs.nl> wrote:

Hi Leo,

>> I will try make now your db on CD to get very SLOW volume ....
> 
> I look forward to your findings and advice!

Okay,

So far I have found that during open of your db it do 600+ reads from disk.

And 400 of them is read of head of a BLOB file.
You have many BLOBs/TEXT fields.


And now I see that although for VarChar I have provide LAZY read of header
it is not made for BLOB. So this will be my FIRST step to improve your
issue.


I see yet that Defragment() is not ported from 1.x code.  Wow. :-(
So we must do this also of course.
MAY BE it also will improve things...


Also I see that you have 60 tables, and 60 reads are for their headers also.
Not sure yet if I can di this in LAZY way also ...

So after BLOBs we should get about 200 reads,   2/3 of calls removed.
And this I hope make for next 4.0 build.


* If Tables also lazy then about 140

* Defragment is not easy algorithm. So not sure it will be in nearest time.


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