[firebird-support] FB 3.0 SS WriteFile Error

2019-07-01 Thread trsk...@yahoo.com [firebird-support]
Hi guys, I have installed FB 3.04 on Windows 7 64 bit. On Firebird configuration file, have set Temporary Directory to e:\;d:\temp. I got an error : I/O error during "WriteFile" operation for file "e:\fb_table_u9" Error while trying to write to file. There is enough space on the disk. I ch

Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.

2019-07-01 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Hernando Duque wrote: > I've working around tuning up a database speed and found that gstat > -h shows valuable information about transactions. Also that gfix > -sweep removes garbage from the database. Sweep (whether automatic or manual) removes garbage that is able to be removed. > I understoo

Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.

2019-07-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.07.2019 18:11, duque.herna...@yahoo.com [firebird-support] wrote: > What am I doing wrong? You misunderstood documentation. Sweep does move OAT (and collect garbage as a side effect), but it has nothing to do with Next Transaction. Numbers from your gstat output tell that your applicati

[firebird-support] FB 2.5.8 - Next transaction value growing too much.

2019-07-01 Thread duque.herna...@yahoo.com [firebird-support]
Hi group. I've working around tuning up a database speed and found that gstat -h shows valuable information about transactions. Also that gfix -sweep removes garbage from the database. I understood that when Next transaction grows too much from Oldest active transaction, "sweeping" the