Database open slow?

[Ruslan Zasukhin]

On 6/9/09 6:58 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

Hi Thomas,
 
> I realized, that it takes sometimes minutes just for a simple
> vdatabase.open(fileame).
> Sometimes it takes minutes for a vdatabse.close.
> Specially after a restart of the pc.

After restart, on WINDOWS -- this is known issue
Present in Mantis.

On MAC and Linux there is no such behavior.
On this list was a couple threads about this.


> The files are big, 500mb. I also have a big cache, 100MB. Can this be a
> reason?

Yes, both.
 
> The databases are ok, (utf16 :-), no problems in diagnose, and once they are
> open, speed is normal.

We do not know yet exactly how resolve this.

May be to use lazy memory allocation.
I am not sure it present on windows.

May be Defragmenttion of db will help somehow..


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