Database Flush Command not working

william humphrey bill at bluewatermaritime.com
Mon Aug 5 10:13:24 CDT 2013


That is what I do. I'm not calling Flush in my app because of that
setting. I also did a diagnose of the database and it is ok.

When this occurs in the logs then the database is written to the hard drive:

Mon Aug  5 2013 10:44:42.331021 (TID 4351606784): (UID 20) Database
'goleta' has been successfully opened.
Mon Aug  5 2013 10:45:06.243656 (TID 4353216512): (UID 20) Database
'b_l_database' has been successfully closed.
Mon Aug  5 2013 10:45:06.243843 (TID 4351070208): (UID 20) Database:
b_l_database; User: sa: OK
Mon Aug  5 2013 10:45:06.244006 (TID 4352679936): (UID 20) Database
'b_l_database.vdb' remoteID 29878016 unregistered.
Mon Aug  5 2013 10:45:06.244025 (TID 4352679936): (UID 20) Closing
database 'b_l_database': OK
Mon Aug  5 2013 10:45:06.244036 (TID 4352679936): (UID 20) Database
'b_l_database' object memory released.
Mon Aug  5 2013 10:45:06.246694 (TID 4353216512): (UID 20) Database
'goleta' has been successfully closed.
Mon Aug  5 2013 10:45:06.246859 (TID 4351070208): (UID 20) Database:
goleta; User: sa: OK
Mon Aug  5 2013 10:45:06.247006 (TID 4352679936): (UID 20) Database
'goleta.vdb' remoteID 90443360 unregistered.
Mon Aug  5 2013 10:45:06.247036 (TID 4352679936): (UID 20) Closing
database 'goleta': OK
Mon Aug  5 2013 10:45:06.247047 (TID 4352679936): (UID 20) Database
'goleta' object memory released.
Mon Aug  5 2013 10:45:06.247314 (TID 4351070208): (UID 20) Database
'(null)' remoteID 25535440 unregistered.
Mon Aug  5 2013 10:45:06.247334 (TID 4351070208): (UID 20) Closing
database '(null)': OK

On Mon, Aug 5, 2013 at 4:52 AM, Ivan Smahin
<ivan_smahin at paradigmasoft.com> wrote:
>
> On Aug 4, 2013, at 11:56 PM, william humphrey <bill at bluewatermaritime.com> wrote:
>
>> I have my vServer database set to:
>>
>> ; 1 - Flush after any data modification.
>>
>>
>
> You mean this?
> ; 1 - Flush after any data modification.
> ; 0 - Default value - no flushing.
> FLUSHEACHDATACHANGES = 1
>
> It is about to flush (to the disk) after any data changes.
> In this case you should not call Flush in your app (vServer will call Flush itself).
>
> Usually it is for debugging - because of performance penalty.
>
>>
>> On Sun, Aug 4, 2013 at 4:53 PM, william humphrey
>> <bill at bluewatermaritime.com> wrote:
>>> vServer_x61 has a folder "databases" and in that folder is stored my
>>> database. When I am using it I assume it is ram based because it is
>>> very fast and if the computer crashes I lose all data.
>>>
>>> I'm looking for a command that I can run which will write the database
>>> from ram to the file in the "database" folder so that when the
>>> computer crashes I only lose whatever was done since that last time
>>> that "commit to hard drive" command is run.
>>
>>
>>
>> --
>> http://www.bluewatermaritime.com
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>>
>
> --
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina



-- 
http://www.bluewatermaritime.com


More information about the Valentina mailing list