Re: [firebird-support] Re: Composite index - issue or not existing feature?

>>This was done knowingly because >>keeping transaction information would greatly increase the size of index >>entries - one transaction id for the transaction >>that created the record version with the value sought, plus one for the >>transaction that changed the value. Obviously >>that

Re: [firebird-support] Ascending and Descending Index

> CREATE INDEX MYINDEX_IDX1 > ON MYTABLE (COLUMN1 ASCENDING, COLUMN2 DESCENDING ) > > Atenciosamente, > > Hugo Eyng > Hi, AFAIK mixing asc desc in same index is not supported If this is not unique index then create two separate indexes regards, Karol Bieniaszewski

Re: Re: [firebird-support] Composite index - issue or not existing feature?

HTH (even though it may be overly simplified), Set (*) In theory with the exception of 'borderline performance issues', were single field indexes are too slow, whereas multifield indexes are quick enough. Though I have to say that I work on smaller databases than you do and never have

Re: Re: [firebird-support] Re: Composite index - issue or not existing feature?

Thanks you Ann and Dmitry for your detailed answer - now i know exactly why this happened. I see that better is use separate indexes then composite in Firebird for range scans.   2 more questions :)   1. Ann you say that index have dbkey bat have it also transaction number or it must access

Re: [firebird-support] Re: Composite index - issue or not existing feature?

    W dniu 2016-03-14 08:36:40 użytkownik Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] napisał:   14.03.2016 10:32, liviuslivius wrote: > > simple table > CREATE TABLE XXX( > A INTEGER > , B INTEGER > , CONSTRAINT UK_XXX__A__B UNIQUE(A, B) > )

[firebird-support] Composite index - issue or not existing feature?

Hi,   simple table   CREATE TABLE XXX( A INTEGER , B INTEGER , CONSTRAINT UK_XXX__A__B UNIQUE(A, B) ) commit;   SELECT * FROM dbo.XXX X WHERE X.A BETWEEN 2 AND 30 AND X.B BETWEEN 5 AND 60     Select Expression     -> Filter         -> Table "XXX" as "X" Access By ID             -> Bitmap          

Re: [firebird-support] Re: FB3 and not null

    W dniu 2016-03-11 14:32:14 użytkownik Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] napisał:   11.03.2016 13:39, liviuslivius wrote: > > I see that in FB3 this was changed and before apply not null to column - > all existed data are

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

Hello,   since 3 days during production the modified date does not chenge, is there a reason why? Its the right database.   Thanks.     Hi,   i can confirm this - database modified datatime is frozen when first connection has started. i suppose that you should raport ticket into the firebird

[firebird-support] FB3 and not null

Hi,   in earlier versions of Firebird - when i try to change column nullable to not null this go very very fast but without check of all records contain value in such field. I see that in FB3 this was changed and before apply not null to column - all existed data are validated.   Is three some

ODP: [firebird-support] Re: UDF install in FB3.0 RC2

hi, i do not suppose that this is an error. In FB3 structure of folders was changed. Your udf should follow that change. I use my custom udf under fb3 without problem. Try this:1. put fbclient.dll in the same folder as your udf file2. if first do not work try creating bin folder and put

Re: [firebird-support] Re: UDF install in FB3.0 RC2

    >>However on this server I first installed FB3 RC2 (64) and saw my database >>managers were 32 bit so I uninstalled FB3 (64)   Russell ___ Hi,   you can use Firebird 64 bit with 32 bit applications - only fbclient.dll must be 32 bit then   regards, Karol Bieniaszewski

Re: [firebird-support] Re: UDF install in FB3.0 RC2

Thanks for suggestions Karol. I am using Win 10 (64) and FB3 (32).  All DLLs are 32 bit, assessed by looking in the DLL files. Russell ,___ I know that this is not so helpfull - byt you do not need to use external functions to extract year or others it exists in firebird itself EXTRACT(YEAR FROM

Re: [firebird-support] Re: UDF install in FB3.0 RC2

Hi,   what is the bitnes of your udf dll 32 bit or 64 bit? And bitnes of Firebird 32 or 64 bit? Both must be in the same bitnes.   regards, Karol Bieniaszewski   W dniu 2016-03-09 03:11:40 użytkownik russ...@belding.co.nz [firebird-support] napisał:   Added:

ODP: [firebird-support] Firebird schema questions

hi, odbc is a standard connection layer for many databases. It contain then many features not supportet by every rdbms. And schemas is one of them. regards,Karol Bieniaszewski Oryginalna wiadomość Od: "heineferre...@yahoo.com [firebird-support]"

Re: Re: [firebird-support] How write a query with a progressive sum field

> 07.03.2016 12:29, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] > wrote: > > Ok, I understand but, "over" is unknow in firebird 2.5.5. > >Upgrade to 3.0. > > -- >WBR, SD. Not so hurry.. FB3 is on RC2 stage not final. regards, Karol Bieniaszewski

Re: [firebird-support] Re: query to return the last entry in detail table for each entry in master table

Hi,   i suppose that you sholuld change r.review_date > r2.review_date   to   r.review_date < r2.review_date   regards, Karol Bieniaszewski   W dniu 2016-03-07 11:02:35 użytkownik talorigo...@yahoo.co.uk [firebird-support] napisał:   Hi Set   Thanks for helping

Re: [firebird-support] firebird and transaction behaviour questions

Hi, one select do not guarantee consistency if you run something outside of transaction context. And because of this, in Firebird there is no possibility to do this. consider folowing example select * from header h inner join detail d on d.id_h=h.id server do loop throught streams and: 1. it

ODP: Re: [firebird-support] how to suppress dashes in query results

hi, better is expression index here regards,Karol Bieniaszewski Oryginalna wiadomość Od: "Svein Erling Tysvær setys...@gmail.com [firebird-support]" Data: 12.02.2016 08:52 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: Re:

ODP: RE: [firebird-support] system table behaviour

hi, as Helen sayyou must commit previous transaction not close connection regards,Karol Bieniaszewski Oryginalna wiadomość Od: "'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]" Data: 04.02.2016 05:55 (GMT+01:00) Do:

ODP: Re: [firebird-support] How to optimize queries on field state

hi, 1. select first 100 ... from my_state_table2. delete from my_state_table ;-) after this your query will be very fast ;-) Ask self. Did i describe my problem for others that they can help me. The answer is NO show us reall query, query plan, statistics... regards,Karol Bieniaszewski

Re: [firebird-support] Is it possible calculate result of aggregates?

Hi, not so simple as you show but you can do: 1. calculated fields (if fields are from one table) 2. select from select : SELECT C ,C*5 AS D FROM ( SELECT 2+3 AS C FROM RDB$DATABASE ) but this will be slower then repeated calculation i suppose regards, Karol Bieniaszewski W dniu 2016-01-22

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

hi, this is what i supposed. Hash match. And as Arno Brinkman say you have not defined indexes on filtered columns regards,Karol Bieniaszewski Oryginalna wiadomość Od: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"

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

Hi, as you can see in query plan – you have natural (full table scan). And hash match you see in MSSQL “because” you have not optimized query. Your query use a lot of RAM and CPU to return value. MSSQL built hash table and join streams. But this query will be slower and slower if your table

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

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

ODP: Re: [firebird-support] Need Support to connect to the database

hi, by what software/driver do you try to connect. did you try connecting by isql?If you can not connect by isql then i suppose password was changed regards,Karol Bieniaszewski Oryginalna wiadomość Od: "Jianbo Li l...@stunningtech.com [firebird-support]"

ODP: [firebird-support] Update table column from another table

hi, did you try select instead of update to see if select return all records which you try to update? regards,Karol Bieniaszewski Oryginalna wiadomość Od: "Sonya Blade sonyablade2...@hotmail.com [firebird-support]" Data: 02.01.2016

ODP: [firebird-support] 2 servers acessing one database

hi, i do not understand you corectly...but. install firebird on both (on first is required on second only client) put this db on pc with fb server and connect from both or more pc.this is normal setup of any rdbms. only port 3050 must be unblocked Regards,Karol Bieniaszewski

Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?

Hi, i am really surprised – why reinvent the wheel? All people use table with version information and this work years. Table have benefit – you can include version description (what’s new). At application start or installer – you check if db is up to date or if instaler is not older than

ODP: [firebird-support] Backaup error

hi, what error you get in the first steep that you try using -fix_fss_metadata switch? regards,Karol Bieniaszewski Oryginalna wiadomość Od: "ruri...@yahoo.es [firebird-support]" Data: 27.11.2015 09:01 (GMT+01:00) Do:

ODP: Re: [firebird-support] Replication SW experience

hi, modification datetime is not enaugh to replication. think about 1. transaction started and modify data2. synchronization started and fetch data from last modifird datetime3. synchronization end4. transaction commit data from point 1 and store datetime before synch started5.

Re: [firebird-support] Interbase 5.6 (Windows 98) not available on network

Hi,   how do you tried to connect (by which connectivity driver/component)? I remember that there was some limitation in some version of drivers. If you have professional version of Delphi then you cannot connect to Interbase remotely. This was changed later..   regards, Karol Bieniaszewski   W

Re: [firebird-support] Re: Interbase 5.6 (Windows 98) not available on network

Hi,   but you can backup this database and move it to another computer :)   regards, Karol Bieniaszewski   W dniu 2015-11-11 15:36:54 użytkownik Virgo Pärna virgo.pa...@mail.ee [firebird-support] napisał:   On Wed, 11 Nov 2015 16:23:51 +0300, Alexey Kovyazin

ODP: [firebird-support] Error 335544721

hi, do you connect by 127.0.0.1 or address like 10.10.1.5. if second and this adderss is local computer ip then this can be also by network problem affected. regards,Karol Bieniaszewski Oryginalna wiadomość Od: "Tim Ward t...@telensa.com [firebird-support]"

ODP: [firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

hi, you got an error or what? regards,Karol Bieniaszewski Oryginalna wiadomość Od: "'stwizard' stwiz...@att.net [firebird-support]" Data: 03.11.2015 14:59 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-support]

Re: [firebird-support] Firebird Indexing problem

Hi, why do you need to slow down query by index? If you go throught whole table and only some sub percent (REPL) is not looked for? consider something like this VALUE=’RX’ 100 records VALUE=’YY’ 100 records VALUE=’XX’ 100 records VALUE=’AA’ 100 records VALUE=’REPL’ 100 records then this is

ODP: [firebird-support] Re: Holding a connection open forever

hi, you should identity this long running transaction. if you use fb2.5 than this is simple by mon$TRANSACTIONS table regards,Karol Bieniaszewski Oryginalna wiadomość Od: "lizwatson02...@yahoo.com [firebird-support]" Data: 21.10.2015

Re: [firebird-support] How To Speed Up Update SQL

All fields in condition which needs paramerter value, I have crated every single index for individual column. On Wednesday, 14 October 2015 6:23 PM, "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" <firebird-support@yahoogroups.com> wrote: Hi, you have few wa

Re: [firebird-support] How To Speed Up Update SQL

Hi,   you have few ways 1. EXECUTE BLOCK and there for select and delete 2. Temp Table 3. speed up subselect with expression index on  Upper(Trim(MBH.HEADER_BOOK_CODE))    regards, Karol Bieniaszewski     W dniu 2015-10-14 11:21:44 użytkownik Vishal Tiwari vishuals...@yahoo.co.in

Re: [firebird-support] Order by

Hi, ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, October 06, 2015 5:20 PM To: Firebird Support Subject: [firebird-support] Order by Hello everyone There is the possibility

Re: Re: [firebird-support] How To Get Entire Linked Group Details

Hi,   i do not know if you describe your problem precisely. But i understand it like this: looks like you need all leaf from same parent (with parent included) as is for "Vishal Group1" and all its childs   try this    WITH RECURSIVE  G1_PARENT AS  (  SELECT MGP.DESCRIPTION FROM MYGROUP MG INNER

Re: [firebird-support] How To Get Entire Linked Group Details

Hi, this group does not support attachments regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, October 01, 2015 2:59 PM To: Yahoo! Inc. Subject: [firebird-support] How To Get Entire Linked Group Details Hi All, I have attached a table DDL and

Re: [firebird-support] Error on Gfix

Hi, look into Firebird.log – there are more infos about corruptions recognized by gfix regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, September 29, 2015 2:53 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Error on Gfix Hi!

Re: [firebird-support] How to debug an external UDF

Hi, too few details – but maybe calling convention. Should be cdecl regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Friday, September 25, 2015 9:52 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] How to debug an external UDF I There,

ODP: [firebird-support] Re: Suddenly: Connection rejected by remote interface

Hi, The same message i saw in the past when someone try to connect with interbase client Regards,Karol Bieniaszewski Oryginalna wiadomość Od: "soprano...@yahoo.com.ar [firebird-support]" Data: 10.09.2015 00:18 (GMT+01:00) Do:

ODP: Re: [firebird-support] About firebird performance

Hi, For superserver this should be as high as possible.  Why you recommended 1 value? I always set it to highest possible value in current environment compared to size of database. And i always disable system cache Regards,Karol Bieniaszewski Oryginalna wiadomość Od:

Re: [firebird-support] Re: Differences when adding a Primary Key

shows me. The table had not NULL neither duplicated values in the column ID. Greetings. Walter. On Sun, Aug 23, 2015 at 12:37 PM, liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com wrote: Hi, have you sample database to reproduce this. How you test

Re: [firebird-support] Expression index for use with the GROUP BY clause

Hi, No – you can not create single index on more then one table But you really need it? How big is resultset? I do not see any filter in this query no HAVING nor WHERE regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Monday, August 24, 2015 7:28 PM To:

Re: [firebird-support] Expression index for use with the GROUP BY clause

-child relationship, where ASIENTOSCAB is the parent. Greetings. Walter. On Mon, Aug 24, 2015 at 1:40 PM, liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com wrote: Hi, No – you can not create single index on more then one table But you really need

Re: [firebird-support] Expression index for use with the GROUP BY clause

-child relationship, where ASIENTOSCAB is the parent. Greetings. Walter. On Mon, Aug 24, 2015 at 1:40 PM, liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com wrote: Hi, No – you can not create single index on more then one table But you really need

Re: [firebird-support] Re: Differences when adding a Primary Key

Hi, have you sample database to reproduce this. How you test this difference? Have you some backup of database and restore it and then test this two options? regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Sunday, August 23, 2015 5:48 AM To:

Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX

Hi, i do not know what should happen in your case when FIEL3 is null? But you can try WHERE FIEL1=:F1 AND FIEL2=:F2 AND (FIEL3=COALESCE(:F3, FIEL3) ) INTO .. DO .. regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Wednesday, August 19, 2015 1:29 PM To:

[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

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:

ODP: [firebird-support] Knowing the previous rows

Hi, What about triggers? Regards,Karol Bieniaszewski Oryginalna wiadomość Od: 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] firebird-support@yahoogroups.com Data: 06.08.2015 20:12 (GMT+01:00) Do: firebird-support@yahoogroups.com

ODP: [firebird-support] Taking database back from v2.5 ODS11.2 to v2.1 ODS11.1

Hi, Why do you need to go back? Regards,Karol Bieniaszewski Oryginalna wiadomość Od: 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] firebird-support@yahoogroups.com Data: 04.08.2015 00:34 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat:

Odp: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server

Hi, I know only one - cache problem Windows can eat too many RAM. Fixed in FB2.5 serie. Migration to 2.5 does not require 2.1 between. Buf you can get migration errors like ambigous field names and other Regards, Karol Bieniaszewski - Reply message - Od: apos;Softtech Supportapos;

Re: [firebird-support] Get ID of record with minsort

    W dniu 2015-06-25 09:18:48 użytkownik josef.gschwendt...@quattro-soft.de [firebird-support] firebird-support@yahoogroups.com napisał:   Hi, I have a table with one ID-Column and one Sort-Column. I need the ID from the record with the lowest sort-number. Sortnumbers are not unique (can be

[firebird-support] Blob concat consume memory - why?

Hi,   why concating blob consume memory and not leave it until transaction end?   simple sample   SET TERM ^ ;   CREATE PROCEDURE TEST_BLOB_CONCAT   ( A BLOB SUB_TYPE TEXT, ILE INTEGER )  RETURNS   ( B BLOB SUB_TYPE TEXT ) AS  DECLARE VARIABLE VAR_I INTEGER;  BEGIN   VAR_I = 0;   B = 'ABC';  

Re: [firebird-support] Is this a bug or common behaviour? (conversion error from string )

    W dniu 2015-06-23 10:38:25 użytkownik brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com napisał:   Hello guys, today I've stumbled on some strange (in my opinion) behaviour. Firstly, create these two structures: CREATE GLOBAL TEMPORARY TABLE GLB_CS_TEMP (  

Re: Re: [firebird-support] Blob concat consume memory - why?

    W dniu 2015-06-24 09:51:58 użytkownik Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com napisał:   At 07:27 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: why concating blob consume memory and not leave it until

Re: Re: Re: [firebird-support] Blob concat consume memory - why?

    W dniu 2015-06-24 11:56:28 użytkownik Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com napisał:   At 08:03 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi Hellen, it looks like bug is not fixed only minimized? I

FWD: [firebird-support] Blob concat consume memory - why?

    Hi,   why concating blob consume memory and not leave it until transaction end?   simple sample   SET TERM ^ ;   CREATE PROCEDURE TEST_BLOB_CONCAT   ( A BLOB SUB_TYPE TEXT, ILE INTEGER )  RETURNS   ( B BLOB SUB_TYPE TEXT ) AS  DECLARE VARIABLE VAR_I INTEGER;  BEGIN   VAR_I = 0;   B = 'ABC';  

Re: Re: FWD: [firebird-support] Blob concat consume memory - why?

  You forwarded it to firebird-support, not to firebird-devel. Mark Fixed ;-)   regards, Karol Bieniaszewski

Odp: [firebird-support] Procedures and Triggers missing

Hi, Do you have sysdba and default masterkey? If yes, then change it. Maybe someone else is connecting to your database without permission and do some strange work Regards, Karol Bieniaszewski - Reply message - Od: Chris Valentine chrisvalentinem...@gmail.com [firebird-support]

Odp: [firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hi, Look into firebird.log about errors and into windows events. First check port number and check if Interbase is not running and block Firebird port. Remember that Firebird 3 is in beta stege, and is not for production db Regards, Karol Bieniaszewski - Reply message - Od: Jack Mason

Odp: [firebird-support] Firebird migration to increase perfomances

Hi, 1. Increase your db cache in db or firebird config as i see reads from disc instead of cache 2. Put sql in mesage body Regards, Karol Bieniaszewski - Reply message - Od: apos;Stefapos; s...@autotech.co.za [firebird-support] firebird-support@yahoogroups.com Do:

[firebird-support] Proper way for copy data from big table

Hi,   what is the proper way for copy data from big table to another database if table is bigger then avaiable RAM and we need to do this in one transaction? You know if we do SELECT * FROM SOURCE_TABLE - and table have e.g. 400 000 000 records then retrive it is impossible because of RAM   but if

Odp: [firebird-support] Proper way for copy data from big table

Data: pt., cze 19, 2015 15:58 On 19/06/15 14:20, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: SELECT FIRST 100 SKIP 0 * FROM SOURCE_TABLE -we got 100 reads - ok SELECT FIRST 100 SKIP 100 * FROM SOURCE_TABLE -we got 200 reads - not ok SELECT FIRST

Re: [firebird-support] Proper way for copy data from big table

For example in Java the default result set is forward only. If it doesn't have rows, it will fetch a number (default is 400 in Jaybird), this is done through a fetch. It will then serve requests for rows from the application from this retrieved set of rows. When it needs more, it discards the old

Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hi, Maybe wrong direction But set this restored with error database to be a readonly and try to connect to it Regards, Karol Bieniaszewski - Reply message - Od: Jack Mason jackma...@mindspring.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com

Re: Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

You asked something similar 2 years ago: http://comments.gmane.org/gmane.comp.db.firebird.user/7145 --  With regards, Thomas Steinmaurer http://www.upscene.com/   Sorry for off-top but  I'am very interested what jack.mason will say about this : You have my +1 ;-)   regards, Karol

Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hi, Maybe another wrong direction, But download snapshot build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski Wysłane z mojego HTC - Reply message - Od: Tim Ward t...@telensa.com [firebird-support]

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

server running. Jack On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, no i mean go to http://www.firebirdsql.org/en/snapshot-builds/ download e.g. Windows build Firebird-2.5.5.26887 unzip it and get gbak.exe and do backup

Re: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

    Hello Vlad, is there a location where I can download a win64 installer package of a nightly build including the fix, or when will 2.5.5 be released officially? Would need this for automatic installation. -- Joja Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]

Re: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

    W dniu 2015-06-10 14:30:52 użytkownik 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] firebird-support@yahoogroups.com napisał:   is there a location where I can download a win64 installer package of a nightly build including the fix, or when will 2.5.5 be released officially?

Odp: [firebird-support] Database restore speed with IBExpert and Gbak

Yes, full restore of normall database with indexes, keys ... and on the same computer os hardware is the same. All 64 bit with 256GB Ram Regards, Karol Bieniaszewski - Reply message - Od: apos;Thomas Steinmaurerapos; t...@iblogmanager.com [firebird-support]

Odp: [firebird-support] Re: losing connection with server on a local PC

Hi, Maybe first check db with gfix against corruption Regards, Karol Bieniaszewski - Reply message - Od: hv...@users.sourceforge.net [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Re: losing connection with server on a

Odp: [firebird-support] Database restore speed with IBExpert and Gbak

Possible further enhancements during index re-creation would be to re-create several indexes in parallel becoming more and more IO bound, especially with low latency storage. AFAIK InterBase added something like that in a recent version. Potentially Firebird has that on the roadmap as well.

[firebird-support] Parametrized queries and execute statement - dynamic parameter list

Hi,   the real question is in point 4   tables CREATE TABLE TABLEX (FIELD_ID INTEGER );   CREATE TABLE TABLEY ( ID INTEGER, AAA INTEGER );   CREATE TABLE TABLEZ ( ID INTEGER, BBB INTEGER );   few thinks: 1. If i do something like this SELECT (SELECT P.SUM_AAA FROM MY_PROC_CALC(T.FIELD_ID) P) FROM

Re: RE: [firebird-support] Parametrized queries and execute statement - dynamic parameter list

Here you change the SQL for each iteration, hence I cannot see how it would be possible to prepare only once. What you could try, is to use a temporary table, change your statement to:    Simple if after iteration query look like   SELECT * FROM TABLE WHERE ID=? SELECT * FROM TABLE WHERE ID=? OR

Re: [firebird-support] How to CAST float to integer with error?

Hi,   this is simple with case or iif   this run ok SELECT CASE WHEN CAST('123.00' AS INTEGER)CAST('123.00' AS NUMERIC(18, 3)) THEN CAST('PRECISION LOST' AS INTEGER) ELSE CAST('123.456' AS INTEGER) END FROM RDB$DATABASE   this run with an error conversion error from string PRECISION LOST FOR

Odp: [firebird-support] Performance diff between insert...select and for select ... do?

Hi, Why not merge? Regards, Karol Bieniaszewski - Reply message - Od: Kjell Rilbe kjell.ri...@datadia.se [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Performance diff between insert...select and for select ... do?

Re: [firebird-support] SQL puzzle: Order based on Prerequisite

Hi, or better for “The SQL may return one or more records with a blank B4Me. In which case, Natural order can be used for those records, and they are all considered First or rather, Before everything else” select CASE WHEN B4ME IS NULL THEN 0 ELSE 1 END, CASE WHEN B4ME IS NULL THEN ID ELSE

Re: [firebird-support] SQL puzzle: Order based on Prerequisite

Hi, you must rethink what you try to retrive. What is then sense of returning somethink in case of cycles? If you have cycles then you do not get something before.. But if you need something strange then it is simple ID as integer select CASE WHEN B4ME IS NULL THEN ID ELSE B4ME+1 END,

[firebird-support] Cast as Numeric without parenthesis

Hi,   i know this kind of cast SELECT CAST('1.23' AS NUMERIC(10, 2)) FROM RDB$DATABASE   but what are the rules for this (numeric without parenthesis) [1] SELECT CAST('1.23' AS NUMERIC) FROM RDB$DATABASE result is 1   [2] SELECT CAST('12345678.23' as numeric) FROM RDB$DATABASE result is 12345678  

Re: RE: [firebird-support] Cast as Numeric without parenthesis

then why here is an error?   SELECT CAST('123456789.23' as numeric) FROM RDB$DATABASE   result should be 123 456 789 is less then 2 147 483 647 i assume this, because this working:   SELECT CAST('12345678.23' as numeric) FROM RDB$DATABASE SELECT CAST('123456789' as numeric) FROM RDB$DATABASE   PS.

Re: Re: [firebird-support] Extract week of the year (within year)

Thanks all,   i forgot about another locales like Sunday first day. I see that supporting official function in FB will be problematic   then i do this in this way SELECT   EXTRACT(YEAR FROM FLD_DATE), CASE      WHEN EXTRACT(yearday FROM FLD_DATE)100 AND EXTRACT(WEEK FROM FLD_DATE)50 THEN 0     

[firebird-support] Extract week of the year (within year)

Hi,   is possible to get week of the year within year? I see that built in functions only support ISO-8601 (or i do not know some parameter)   SELECT '2014-12-31', EXTRACT(WEEK FROM CAST('2014-12-31' AS DATE)) FROM RDB$DATABASE result is 1 but i need weeks in year -in example 53   you know when

[firebird-support] What is difference between Distinct and Distinct(FieldName)

Hi,   is there some difference in meaning between this two   SELECT DISTINCT R.RDB$FIELD_ID, R.RDB$RELATION_NAME FROM RDB$RELATIONS R and this SELECT DISTINCT(R.RDB$FIELD_ID), R.RDB$RELATION_NAME FROM RDB$RELATIONS R   regards, Karol Bieniaszewski

Re: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause?

At the End For More Than One Columns Specified in Order By Clause? Meaning was same. On Friday, 13 March 2015 11:06 PM, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com wrote: Hi, Following stackoverflow i see

Odp: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause?

Hi, Following stackoverflow i see that this is not what you show us in sample table results Regards, Karol Bieniaszewski - Reply message - Od: Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com

Odp: [firebird-support] Cumulative queries

Hi, This look for me like wrong design. Query running minutes are not acceptable from my POV. I do not know how your system work, but in any stock system i see month work. Month is closed and data are calculated and stored. And in next month the same Regards, Karol Bieniaszewski - Reply

Odp: [firebird-support] Re: Is there still a difference between sweep and gabage collection?

Hi, 1. Is this VB exe or web? 2. Save all insert statement parameters to tabbed csv and you will see at what statment it stop. If this is always at the same statement, then compare it e.g. in excel withprevious statements. Regards, Karol Bieniaszewski - Reply message - Od: SUKHEN

Odp: [firebird-support] Re: Speed issues

Hi, Yes i know that, But if he have some permanent connection to this db, then is the chance that next day when he run some query, some data are already in cache. And with bigger cache, is then bigger chance to same data in cache. I use permanent connection on my server, where data are accesed

Odp: [firebird-support] Big database optimization

Hi, What kind of server Superserver or classic or superclassic And how big is that cache settings? Regards, Karol Bieniaszewski - Reply message - Od: zilez2...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support]

Odp: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test

Hi, Can you provide source code with this insert action / also dfm I have Xe7 and i can test this About FB on DC this is one hell with Exchange. And it is much bigger problem if you have older version of FB then 2.5.3 (may be 2.5.2 fix i do not remember) on Win2008 with bigger then 4GB RAM

Odp: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test

Hi, Do you use firedac cached updates? I suppose that problem is not Fb. What happened when you close your app and continue inserting? Db process this data or still 2GB limit? Regards, Karol Bieniaszewski - Reply message - Od: af_12...@yahoo.com [firebird-support]

Re: [firebird-support] Selecting arbitrary records in an arbitrary order

Hi,   this is simple - but i do not know how many values you have if this is small count then   select Fields FROM TABLE_NAME ORDER BY CASE WHEN ID=1032 THEN 1 WHEN ID=624 THEN 2 WHEN ID=2841 THEN 3 END   and if this is big numer then add better temp table with order values   regards, Karol

[firebird-support] Is some CSV, batch processing in Firebird 3?

Hi,   i work with big csv files and to speed up operations i convert it do external table format with my tool. It convert all fields types and work fast but may be in Firebird 3 are some improvements? Maybe this step is now unnecessary?    Can we separate csv file on the fly in FB proc? and loop

<    1   2   3   4   5   6   >