Re: [firebird-support] internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

Hi I am no expert in these things but I thought that DB file access that was not 'through' the FB server while FB server is running could cause DB file corruption. With our systems we always exclude the FDB from virus scanning and external backup applications. We have a FB backup (GBak) run

Re: [firebird-support] High number of NULL attachments

05.10.2016 20:13, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Could you please stop posting responses like "Perfect", "Thanks" and > "Great, Thanks!", "Hello", etc. It is unnecessary filler that doesn't > contribute anything to the mailing list This is just a stupid

Re: AW: AW: [firebird-support] High number of NULL attachments

Could you please stop posting responses like "Perfect", "Thanks" and "Great, Thanks!", "Hello", etc. It is unnecessary filler that doesn't contribute anything to the mailing list Over the last 3 months you have only posted response like that to the list (and no other real contributions). Mark

Re: AW: AW: [firebird-support] High number of NULL attachments

Great, Thanks!  Sent from Yahoo Mail. Get the app On Wednesday, October 5, 2016 4:18 AM, "monteropetronila...@yahoo.com [firebird-support]" wrote:   Perfect  Sent from Yahoo Mail. Get the app On Tuesday, October 4, 2016 8:26 PM, "'Gregor

RE: [firebird-support] Speed of comparing one field to another

>Loius Wrote: >You could create a denormalized field that contains the difference of those >values (updated by a trigger, perhaps), and you can put >an index on that new field. Then change the query to find rows where [new >difference field] < 0. >Make sense? Thank you, looks like I will

[firebird-support] Re: internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

I had the same thing again on a completely unrelated database that doesn't do the nightlySQL bit...so I know it isn't that. Following on from the question from Alexey which made me think about multi-file databases which we aren't using I've just disabled our regular NBackups that we were