Re: [firebird-support] What is more effective execute block or select?

No, I must admit limited knowledge of MERGE. For Firebird 3 is seems like a good alternative, but I think Fb 2.1 and 2.5(?) requires a WHEN NOT MATCHED THEN INSERT clause (which is typically not desirable in these cases). Set 2016-01-28 13:31 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl

Re: [firebird-support] What is more effective execute block or select?

On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær setys...@gmail.com [firebird-support]" wrote: > No, I must admit limited knowledge of MERGE. For Firebird 3 is seems like a > good alternative, but I think Fb 2.1 and 2.5(?) requires a WHEN NOT MATCHED >

Re: [firebird-support] What is more effective execute block or select?

On Wed, Jan 27, 2016 at 5:01 PM, setysvar setys...@gmail.com [firebird-support] wrote: > >If the question is which is likely to perform better, then the answer > is the select. > ... > >In general, execute block should be used when you want to change what >

Re: [firebird-support] What is more effective execute block or select?

Re: [firebird-support] Page is of wrong type (expected 5, found 0)

On Thu, Jan 28, 2016 at 4:12 PM, Martin Schwedhelm silo...@yahoo.com [firebird-support] wrote: > > > As far as I can tell (via gstat) forced write is enabled. > Also, regarding virtual machines, at least ESX(i) does not cache guest OS > writes >

Re: [firebird-support] Page is of wrong type (expected 5, found 0)

Thanks for the fast replys, As far as I can tell (via gstat) forced write is enabled.Also, regarding virtual machines, at least ESX(i) does not cache guest OS writes(http://www.yellow-bricks.com/2011/04/07/mythbusters-esxesxi-caching-io/). Maybe a thing that was not clear in my initial post:We

[firebird-support] Firebird 3.0 RC1 (fbembed.dll)

Hi All, I have subject version installed. However, I could not find and fbembed.dll file to test and play with. Is it intentionally missing? Or, there is a way to get it? Thanks. Ertan Küçükoğlu

Re: [firebird-support] Firebird 3.0 RC1 (fbembed.dll)

Re: [firebird-support] What is more effective execute block or select?

On Wed, 27 Jan 2016 23:01:50 +0100, "setysvar setys...@gmail.com [firebird-support]" wrote: > [..] On the other hand, there are cases > where EXECUTE BLOCK can help performance (note, I speak for 2.5, I know > nothing about Firebird 3): > > UPDATE h > SET =