Re: [firebird-support] Hierarchical SQL Query

Hi Michał Kurczabiński Actually i missed to create the indices for the search columns and linking columns, Now after creating the indices on those columns the "Total execution time is 0.537s". instead of almost 4s. Created indices On : TBLTRANSMAST - > REFSGUID TBLTRANSMAST - >

Re: [firebird-support] Hierarchical SQL Query

What about indices? Can you show PLAN of those queries ? -- Regards, Michał Kurczabiński

Re: [firebird-support] Hierarchical SQL Query

Hi Michał Kurczabiński, Based on your suggestion for Hierarchical SQL Query i designed the below query, it is working, but the problem is the execution time taken by the below query is almost 4 seconds. WITH TBLCF AS(SELECT TBLLEDGERMAST.LEDGERMASTID,

Re: [firebird-support] internal firebird consistency check

Thank you, Paul. There were issues related to RAM and while attempting to upgrade RAM (and OS from 32 to 64 Bit) I lost the corrupted database. Regards, Rajiv On 13 Jun 2017 2:03 pm, "'Paul Beach' pabe...@waitrose.com [firebird-support]" wrote: <<1. I got

[firebird-support] internal firebird consistency check

<<1. I got following error reported Firebird-3.0.2.32703_0_Win32 : "internal firebird consistency check (cannot find record back version (291), file: vio.cpp line: 4676)">> Try a gbak using something like the following gbak -b -v -i -g copy1.fdb{path}copy1a.fbk using the –g switch to signify

Re: [firebird-support] Firebird shows previous timezone after that was changed

Restarting fb service seems to solve this On Monday, June 12, 2017, 10:53:46 AM GMT+3, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:   Hi on a Windows 10 x64 server timezone was changed 24 hours ago,but firebird (2.5.7) still shows date and