Db.open() slow work-around

[Ruslan Zasukhin]

On 7/25/06 7:19 AM, "Russ Tyndall" <fitzbew at nc.rr.com> wrote:

> Ruslan,
> 
> Could not get anything good out of reading in part of file to speed up
> db.open().  I did get funny results though, I think something funny happens
> in OS or API.
> 
> But I did find workaround!  If DB is made to be in Mode 4 (4 files), we
> always get fast db.Open() on XP.  So, this is viable workaround for me at
> least until better solution is found.
> 
> I'll check with you tomorrow, if you are online.  I am just now going to
> sleep -- you are probably waking up!

Hi Russ,

Well, separate .vdb means that SYSTEM tables are located in small file.

Interesting. So in big database, parts of system tables are probably spread
by the whole big dbs...but then not clear why defragment did not help you...

Okay, in any case we have one more fact now.



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