[firebird-support] From where Firebird get field values in ORDER BY if DISTINCT is applied

Hi,   query like this   SELECT DISTINCT T.FIELD_1 FROM TEST T ORDER By T.FIELD_2, T.FIELD_1   from where Firebird get info about T.FIELD_2 in order by if it applied first DISTINCT (unique sort)?   i run this also on FB3 to get more info from explained plan   Select Expression     - Sort (record

[firebird-support] Re: Connected users from MON$ATTACHMENT

12.08.2015 21:58, Jeferson Sisto wrote: 1) In firebird.conf, in session about parameter DummyPacketInterval, there is a warning DO NOT USE THIS OPTION. I can or cannot use this parameter? This parameter only can be used with the changes in OS, quoted in the Microsoft article? You can use

[firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

Greetings All, First off, I would like to thank all members of this list for taking the time to reply on this list. Much appreciated… Really need some help on this one folks. Not sure if this is related to IN, NOT IN vs EXISTS, NOT EXISTS or not. I have a main stored procedure (not

ODP: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

Hi, First show us query plan for every select from this proc. This tell us what is wrong. Regards,Karol Bieniaszewski Oryginalna wiadomość Od: 'stwizard' stwiz...@att.net [firebird-support] firebird-support@yahoogroups.com Data: 13.08.2015 15:19 (GMT+01:00) Do:

Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

PLAN JOIN (PP INDEX (REFPERSON15,IX_PP_STATUS_CODE2,IX_PP_STATUS_CODE2),P INDEX (PK_PHONE)) Two more questions, Karol: How large percentage of the records in PER_PHONE have status_code G or V? What's the definition of REFPERSON15? Set

Re: [firebird-support] Installation of Firebird 2.5.4 on CentOS 6

AMD64 is x86-64. AMD was the first to have 64 bit x86, and Intel used the same instruction set when Itanium failed. The name has never changed in the build. Mark - Reply message - Van: Hector Sánchez hec...@planatec.es [firebird-support] firebird-support@yahoogroups.com Aan:

Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

Two more questions, Karol: Sorry, I meant to write Mike. How large percentage of the records in PER_PHONE have status_code G or V? What's the definition of REFPERSON15? The PER_PHONE table currently contain 579,873 rows 91455 or 15.771% is ‘G’ 166075 or 28.639% is ‘V’ For a total of 44.41%

[firebird-support] Migration from Interbase 7.5 to Firebird 2.5.4

I would like to know if someone has accomplished a migration from Interbase 7.5 to Firebird 2.5.4 or if there some documentation or guidelines I could follow. Thanks in advance. -- -- Planatec Software S.L. ** http://www.planatec.es telf: +34 964 340 560 ** fax: +34 961 130 921

[firebird-support] Installation of Firebird 2.5.4 on CentOS 6

Is there any rpm for x86_64 arquitectures on linux? At the downloads page I could only found packages for x86 or AMD64. Thanks in advance!! -- -- Planatec Software S.L. ** http://www.planatec.es telf: +34 964 340 560 ** fax: +34 961 130 921

RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

The PER_PHONE table currently contain 579,873 rows 91455 or 15.771% is ‘G’ 166075 or 28.639% is ‘V’ For a total of 44.41% What about RefPerson index? What field is it based on? (I suspect Person) Many unique values are found in RefPerson index? Do you need to search on the