AW: Journal file

[Ruslan Zasukhin]

On 4/9/12 2:42 PM, "Fabian Kneubuehl" <support at ysd.ch> wrote:

Hi Fabian,

> Thanks for  the answer. I run my 'crash-test' since this morning with v5
> beta (up to now no problems). Because I do a lot of insert/updates/deletes I
> feel that it runs slower than with 4.6 (it is only my feeling - no timings
> so far).

We have see it seems 20-30% penalty

> In general: I use .Flush after each insert/delete/update I think I can earn
> more speed if I disable journaling. If I understand this new feature right
> it helps only if the DB was not flushed and closed correctly and then
> restores changes since the last flush. In my case the insert was written to
> the journal file and right after that I flush the change to the DB. So you
> must insert my record into the journal file and immediately after the entry
> has to be deleted from journal because I flush data to DB. That makes no
> sense to me:
> 
> InsertRecord
> Record insert in journal file
> FlushRecord to DB
> Delete journal entry

Actually this is how work all dbs usually.
DOUBLE FIX on disk...
 
> And as I stated earlier: I had never a server crash in the last 6 years
> using Valentina that harms the DB but dozens of segment problems in normal
> all day use due to a problem of handling segments internally

Problem is that we are not able reproduce any segment problems.

You need then help us reproduce this.
Open hunting ...


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