Results 284 comments of Vlad Khorsun

> What's about this PR? Will look at it in a next few days.

The second block creates temporary blob for every record in a table. These temporary blobs will be destroyed only when transaction ends (by commit or rollback). Engine put contents of...

Thanks for the report. I currently investigating it and below what I was found so far: - I can't reproduce it on my primary working Win7 machine - I reproduced...

It is due to FILE_FLAG_OVERLAPPED - without it fb4 works almost as fast as fb25. And - no - I don't use NTFS encryption.

> set statistics is also affected by this IO behaviour, according to our tests Could you clarify - what do you mean here ? > Reading Adrianos Link, it looks...

> set statistics takes longer, best noticable with big tables, and the factor seems to correspond with the test case measurement for a particular machine. It seems both operations have...

What Firebird version and architecture ? OS ? Did you check firebird.log ? Did you run validation of broken database ? Do you have one for analyze ?

Pls, no yandex or other resourses not awailable in Ukraine.

I see no corruption at your db. It have stuck OIT and needs to run sweep. Also, FW=OFF is not recommended. What exact Firebird version do you use ? And...

Run gstat -r and you'll see two tables with a lot of record backversions: ``` NumberOfVehiclesOnRoute (165) Primary pointer page: 249, Index root page: 250 Average record length: 28.30, total...