Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

Hi, i see that you have only partial key usage on 1/4 only BelgeNo is used because you do not use “BARKOD” – is this intentional? FROM BAZLISTE XYZ where BelgeNo = 'REYSAS' AND AdresKodu = 'SAYIM' AND IslemTuru = 'SA' regards, Karol Bieniaszewski From:

Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

Yes, this is information I need. Is it better to have a full index? Sent from my iPhone > On 21 Jan 2016, at 00:17, liviusliv...@poczta.onet.pl [firebird-support] > wrote: > > Hi, > > i see that you have only partial key usage on 1/4 > only BelgeNo is used

[firebird-support] Restore failed

gbak:adjusting an invalid decompression length from -33 to -19 gbak: ERROR:value exceeds the range for valid timestamps gbak: ERROR:gds_$send failed gbak:Exiting before completion due to errors Anyone any idea what any of that means? -- Tim Ward

[firebird-support] Firebird 3.0 RC1 - SQL optimization help

Hi, I have below tables. CREATE TABLE BAZLISTE ( ADRESKODU varchar(30) NOT NULL, ISLEMTURU varchar(2) NOT NULL, BELGENO varchar(30) NOT NULL, BARKOD varchar(30) NOT NULL, MIKTAR bigint, OLCUBIRIMI varchar(10), PRIMARY KEY (BELGENO,BARKOD,ADRESKODU,ISLEMTURU)

RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

I’m all new to these things. Below is what I could find on MSSQL. I hope that is what you are looking for. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, January 21, 2016 12:35 AM To: firebird-support@yahoogroups.com Subject: Re:

Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

Hello, You have no indices defined at all. While i don’t understand your system i cannot really say what indices you should add, but these will at least help: CREATE ASC INDEX I_TERMINAL_SAYIM ON TERMINAL_SAYIM (BELGENO, ADRESKODU, ISLEMTURU, BARKOD, OLCUBIRIMI, TEKPARCA); Kind Regards, Arno

RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

Sorry, for my formatting. Here is a better one. I have uploaded image. Link: http://s16.postimg.org/pz3iyujr9/Untitled.png From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, January 21, 2016 1:13 AM To: firebird-support@yahoogroups.com Subject:

Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

I do not spend much time on this – maybe my conclusions are not good but also you have not any index usage for this subquery SELECT AdresKodu, IslemTuru, BelgeNo, barkod, olcubirimi FROM

Re: [firebird-support] CPU Affinity

Hi Mark. Thanks for your answer. My reasoning was that more cores to process , more performance . However , in the light of your explanation I changed my way of thinking. Do you see any difference between using Classic Server and SuperClassic , except number of processes? Em 19/01/2016

Re: [firebird-support] Performance Problem after Migration fb 2.1 cs to fb 2.5 cs both X86

It is probably not relevant to your particular query, but you do have an unusual way to write your joins and I believe (though I'm only 80% certain) your 'nesting' style reduces the options for the optimizer (I think it can only choose between TBESTELLUNGEN and TBESTPOS as the first table, though