Database open slow?

[Thomas Flemming]

Hi Ruslan,

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

You are writing into the files, even the timestamp is modified.

So what helps as a workaround is setting the readonly-flag on the database files.
Then the dbs are opened immediately.
For me its ok, since I'm anyway only reading from the dbs.

Regards,
Tom




-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/