Database open still slow?

[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)


 >>> 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.
Maybe you should write this flag in a seperate file.


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