Database open slow? [WORKAROUND]

[Thomas Flemming]

Hi Ruslan,

in the menatime this has come up again for me, because now I'm working with 
rw-databases as well.
So the workaround in setiing the RO-flag on the file does not work anymore.

Is there maybe a fix already for this slow-opening/closing?
Even on small vds (+/- 10mb) it takes sometimes 30sec just to open...
(vnet, windows xp)

Best regards,
Tom



Ruslan Zasukhin schrieb:
> On 6/9/09 11:07 PM, "Thomas Flemming" <tf at ttqv.com> wrote:
> 
>>> May be Defragmenttion of db will help somehow..
>> You are writing into the files, even the timestamp is modified.
> 
> Well, at least we write one flag that db file is open now..
> If I remember right.
> 
>> 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.
> 
> Very interesting ...
> Thank you for this observation.
> 

-- 
/****************************************
**   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!
***************************************/