[V4RB] Open Delay

[Schiller, Carsten]

Hi Ruslan, hi All!

I found this thread in the archives and since our App using large VDBs is
now more and more used on Windows this becomes a problem for me, too. Did
you make any effort on this item, or can I do something to prevent this
(slightly annoying)open delay on opening > 200 MB DBs?

Cheerio, Carsten

PS: Is it ok to share the V4RB_Carbon.rbx Plugin for the RB Windows IDE? The
'Win Host' Version doesn't work with my PPC Compilations.



http://leafe.com/archives/showFullThd/305475#10

Author: Ruslan Zasukhin <sunshine .AT. public DOT kherson.ua>
Subject: Re: [V4RB] 1.x Open() Delay in Win32
Posted: 2006/04/07 07:03:40
On 4/7/06 12:58 AM, "Russ Tyndall" <fitzbew AT nc .DO.T rr.com> wrote:

>
> So, if I follow you (in a general sense) Valentina 1.x (and 2.x, based on
a
> subsequent comment) kind've "pre-scan" the database during Open(),
gathering
> info about the db that stays persistent until the PC reboots. This
> information somehow stays persistent on the PC, in system cache or such.
But
> not the entire contents of the 155mb db, just some smaller amounts of data
> which I presume are used to enable those stunningly fast queries.

Actually this is not related to fast queries!

Problem in how Valentina store info.
I believe it is possible improve this issue, e.g. Keep all headers together.
Then read them all together in one touch.
Or use lazy open as I have told -- both ways can move us to zero time here