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

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,

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

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: 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:

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: 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] 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

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] 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: [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,

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] 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

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

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

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

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] 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] Re: Composite index - issue or not existing feature?

Hi Ann, This is the crux of the matter “Index entries for the old and new versions of a record all contain the DBKey of the primary (newest) record version. When doing an indexed lookup, Firebird walks backward through the record versions until it finds one that the current transaction can see,

Re: [firebird-support] [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

Hi, just curious – why not superserver? I do not know what your system do and if it is cpu intensive – but i always use superserver because of big cache and this is for me biggest speed up. I use superserver in environment with ~400 connections (near constant) and high load without problem.

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

>>No, the index entry does not include transaction information. So yes, if >>you have a database that includes something >>m to m relationship, the junctions records have to be read to validate >>them for the current transaction. M to m >>relationships are typically something like: students,

[firebird-support] Disable cache at all - future question

Hi, is this possible to disable cache at all? I mean that all go from and to “HDD” without RAM between. regards, Karol Bieniaszewski

Re: [firebird-support] Disable cache at all - future question

>> Hi, >>is this possible to disable cache at all? >> I mean that all go from and to “HDD” without RAM between. >Checkout the FileSystemCacheThreshold configuration parameter in >firebird.conf. Set it to 0 and also use a small page buffers value. >Another area of RAM usage is for temporary data

Re: [firebird-support] [FB 2.1] Firebird engine seems to slowdown on high load without utilizing hardware

Hi, i have few questions releated to your problem 1. What is your sweep settings? 2. When you run backup and do you use gbak or nbackup? 3. what is your transactions settings? Do you use readonly readcommited or prefered shapshot? regards, Karol Bieniaszewski

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

Hi, i do not know what do you mean “to check” Can you connect to db? or you cannot and need to check? If you can connect, then this is simple: SELECT r.MON$ODS_MAJOR, r.MON$ODS_MINOR FROM MON$DATABASE r regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent:

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

Hi, This detection is useless . use the latest library (FB3) and you can connect to any older servers regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, May 12, 2016 6:50 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Checking

Re: [firebird-support] Database Unavailable

Hi, what is your connection string? If you try to connect on shared – then this not work(you can enable this in config but this is not good choice at all) normally connection string looks like: 127.0.0.1/3050:C:\baza\baza.fb 3050 port can be ommited you can on local system connect by:

Re: [firebird-support] FB embedded slow in Windows 64bit?

Hi, first help us to help you. Without any detail we can talking about weather Did you identify some slow down in particular query – different query plan... Have you compared Firebird.conf? Did you compare server hardware? I suppose that new Windows is on different hardware – not always better

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

Subject: Re: [firebird-support] Checking Ods version (2.5 <-> 3.0) On 12-5-2016 20:18, liviusliv...@poczta.onet.pl [firebird-support] wrote: > This detection is useless . > use the latest library (FB3) and you can connect to any older servers But that isn't really useful if you

Re: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

Hi, >>SS FB 3.0 takes different query plan than SC 2.5.2, it slows because not use >>index. will be good to see query, query plan in both FB versions – if you need help you must help others to help you (with exact info). Also will be good to see indexes and its statistics regards, Karol

Re: [firebird-support] update all records

Hi, 1=1 => true “where true” is always true this is oposite to 1=0 => false and this statements are equal: update stock set actualizar = 0 where 1=1; update stock set actualizar = 0; regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, May 5, 2016

Re: [firebird-support] Migrating from Super Classic FB 2.5.2 to SuperServer FB 3.0 could have a problems

Hi, 1. will be good to see this query plans 2. will be good to see exact error message 3. also check your db by gfix –validate –full regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Sunday, May 1, 2016 8:35 AM To: firebird-support@yahoogroups.com Subject:

Re: [firebird-support] Setting a generator

Hi, i do not understand what you try to do (why you need to set value of get max in procedure) but: gen_id(generator_name, –gen_id(generator_name, 0)+your_get_max_value) regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Monday, May 2, 2016 6:40 PM To:

Re: [firebird-support] update all records

Hi, one of possible reason is that records are not visible to transaction with this update statement. e.g. 1. you start transansction (tr1) 2. someone start transaction 2(tr2) 3. tr2 insert some records 4. tr1 run update 5. tr2 commit 6. tr1 commit all records inserted by tr2 are not updated

Re: [firebird-support] SQL standard for sort fields and returned fields

Hi, i am talking about your post “I don't have the SQL standard at hand right now, so I can't double check. As far as I know, the SQL standard allows you to sort on any field, even if it is not in the select list (with the exception of course of ordering by column index).” and about line

[firebird-support] old CORE-742 for disscussion

Hi,   http://tracker.firebirdsql.org/browse/CORE-742 i do not need to spam tracker then i move discussion to group.   Please disscuss/vote on exception handling mechanism related to udf call. I can only say that crashing engine becouse udf raise exception is wrong at all. This mechanism can

Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2

Hi,   i test this on virtual machine with Windows 2008R2 and Xeon E5-2680 v2 and result was:     Executing statement... Statement executed (elapsed time: 0.000s). 10899160 fetches, 1051082 marks, 0 reads, 69 writes. 4 inserts, 950001 updates, 0 deletes, 950016 index, 2 seq. Delta memory:

[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

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] 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: 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] 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.

[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

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?

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

[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

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

[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

[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] 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] 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] 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]

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]"

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

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:

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:

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

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

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] 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.

[firebird-support] FOR UPDATE [OF ...]] WITH LOCK

Hi,   what is OF and three dots after? FOR UPDATE [OF ...]] WITH LOCK (README.explicit_locks)   it looks like we can write after OF something more - but what?   regards, Karol Bieniaszewski

[firebird-support] Schema pluses?

Hi, what are + and – with working with schema? What benefits are between schema_name__table_name and real schema implementation? schema_name.table_name I near to always have worked without schema databases or with only one schema in schema supported databases. regards, Karol Bieniaszewski

Re: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK

Hi, thanks you Paul regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, June 9, 2016 11:03 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK <> "The clause can take an optional OF to target

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

Hi,   test without details say nothing to me 1. Did you compare results with e.g. FB2.5 in on the same maschine with same configuration (FBConfig) 2. What is your page size and type of HDD? 3. Do you have BOST feature enabled on CPU and HT? 4. Did you compare results on GLOBAL TEMPORARY TABLE - i

Re: [firebird-support] Stored Procedures Execution Plan

SP plans (SP's called by the SP which you are converting to an execute block). Att. João Paulo -- DE: "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]" <firebird-support@yahoogroups.com>

Re: Re: [firebird-support] Stored Procedures Execution Plan

Hi,   yes but this was "wrong" Consider this: inside procedure you have 5 different statements and you run query and only two of them are reached - do you really need to see all 5?   Ok - now you got only "natural" word for procedure - i do not know if this is better now.. But if you need plan

[firebird-support] Re: Schema pluses?

Hi,   anybody?   regars, Karol Bieniaszewski   W dniu 2016-06-12 23:18:15 użytkownik livius napisał: Hi,   what are + and – with working with schema? What benefits are between schema_name__table_name and real schema implementation? schema_name.table_name   I near to

ODP: [firebird-support] Gbak restore hangs on "activating and creating deferred indexes"

hi, two things1. try latest FB version in part, you have 2.5.4 but there is 2.5.6 or newer2. 20 GB is small try to restore this db on normal PC if server have only 20GB free. ps. in FB3 transaction id is int64 - no more problems :) regards,Karol Bieniaszewski Oryginalna wiadomość

Re: Re: [firebird-support] Case and Accent insensitive compares

Hi,   you have right Paul and Stefan sorry for previous answer - i miss that point   regards, Karol Bieniaszewski   W dniu 2016-06-16 11:03:25 użytkownik Paul Vinkenoog p...@vinkenoog.nl [firebird-support] napisał:   Hi Stefan, > > Also, it is questionable if

Re: [firebird-support] Case and Accent insensitive compares

Hi, you use wrong collation UNICODE_CI is truly case-insensitive. In a search for e.g. 'Apple', it will also find 'apple', 'APPLE' and 'aPPLe'. UNICODE_CI_AI is accent-insensitive as well. According to this collation, 'APPEL' equals 'Appèl'. as you can see UNICODE_CI_AI is accent-insensitive

Re: [firebird-support] Re: Schema pluses?

Hi, thank you Dmitry – the last sentens show me some benefits other sentenses show only complications for me. we can write sql like select * from table_name but really this is select * from schema.table_name and if i write this in stored procedure – i suppose that “object_id” will be stored in

Re: [firebird-support] Schema pluses?

pluses? Firebird has no support for schemas, IIRC... or am I missing something? Em dom, 12 de jun de 2016 às 18:18, 'livius' liviusliv...@poczta.onet.pl [firebird-support] <firebird-support@yahoogroups.com> escreveu: Hi, what are + and – with working with schema? What be

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

Hi, do you mean that you share one connection between multiple threads? regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Wednesday, June 15, 2016 5:55 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] performance issue with firebird 3.0

Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

Hi, error message? regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, June 23, 2016 6:39 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] It works on FB 2.5 but does not work in FB 1.5 I created a view that works perfectly on FB

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]"

Re: [firebird-support] Re: Schema pluses?

  Ok i then misunderstand some discussion obout increasing length of identifiers to support then schemas Now i understand that this is only minor preparation   regards, karol Bieniaszewski       W dniu 2016-06-15 23:36:56 użytkownik Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]

Re: [firebird-support] Re: Schema pluses?

>>In this case, user1 does not know about user2. They live in two parallel  >>universes. >>Dmitry Then i do not know who can take risk that user1 in one "universe" (product) at present day have e.g. two schemas and user2 have onother schema  and in the future user2 take decision to create another

Re: Re: [firebird-support] Schema pluses?

Hello Karol, Thursday, June 16, 2016, 7:49:06 AM, you wrote: > > but this feature is considered for FB4 – then i need to know why this is > important feature.. > This whole topic is off-topic in firebird-support, which is about current releases. However, I'm sure others (including me) are

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:

  1   2   3   4   5   6   >