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

Costantino Mi recomendacion para realizar insert de gran cantidad de datos, es utilizar tablas externas. Estas son extremadamente rapidas.Para esto 1 tenes que definir un archivo de texto con los datos. 2 crear la tabla externa en firebird 3 realizar el insert a la tabla definitiba de los

[firebird-support] update optimization problem

Hi. in firebird 2.5 Simple descriptables table_ud ud_id integernotnullprimarykey field_udvarchar(6) rowcount: 383322 table_tmp ud_id integer cndinteger index (cnd) rowcount: 617 UPDATEtable_udud SETud.field_ud = '201401' WHEREud.ud_id in (SELECT t.ud_id FROMtable_tmp t where t.cnd =

Re: [firebird-support] Help With External Table Issue

look for CHR(13)+CHR(10) at the end of lines open external table with editor (I use textpad) is good for big data. good luck Germán El Jueves, 11 de septiembre, 2014 20:14:24, 'Edward Mendez' emendez...@nc.rr.com [firebird-support] firebird-support@yahoogroups.com escribió: Hi All,

Re: [firebird-support] Configuring Firebird for high transaction through put

Run stadistic for database - Look for index in de big tables. Look for Depth 2. In this case up Page size one step, and run database statistical. - Look memory at each step Good luck Germán El Viernes, 12 de septiembre, 2014 15:37:38, Alexey Kovyazin a...@ib-aid.com [firebird-support]

Re: [firebird-support] Migration from Firebird 32 1.5.6 to Firebird 64 2.5.3

in fb 1.5 fix and backup database in fb 2.5 restore database with fix malformed unicode_fss data and metadata atencion to date and datetime data en fb 1.5 good luck El Miércoles, 29 de octubre, 2014 11:13:01, 'm...@lawinegevaar.nl' m...@lawinegevaar.nl [firebird-support]

Re: [firebird-support] update optimization problem

Yes. in fb 1.5 is very disastrous Thank El Miércoles, 29 de octubre, 2014 10:39:34, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] firebird-support@yahoogroups.com escribió: Hi. in firebird 2.5 Simple descrip tables table_ud ud_id integer not null

Re: [firebird-support] Order by

hoogroups.com> escribió:   Germán, as you can read Spanish, this article can be useful: https://firebird21.wordpress.com/2014/11/20/mostrando-los-resultados-ordenados-por-cualquier-criterio/ Greetings. Walter. On Tue, Oct 6, 2015 at 6:17 PM, Germán Balbi bal...@yahoo.com [firebird-

Re: [firebird-support] Order by

Excellent, very simple. Thank Karol El Martes, 6 de octubre, 2015 16:32:08, "liviusliv...@poczta.onet.pl [firebird-support]" escribió:   Hi, ORDER BY CASE USER_NAME WHEN ‘PAUL’ THEN 1 WHEN ‘JOHN’ THEN 2 .. END  regards,Karol Bieniaszewski From:

Re: [firebird-support] Firebird 2.5 Language Reference

Para una mucho mejor traducción usa el traductor de Microsoft http://www.bing.com/translator/ |   | |   | |   |   |   |   |   | | TraductorDescargar aplicaciones Translator Translator Apps Skype Translator | | | | Ver en www.bing.com | Vista previa por Yahoo | | | |   | El

[firebird-support] Order by

Hello everyone There is the possibility of ordering the result of a SELECT in an order  specified by the user.For examplehaving a field NAMEin the clause ORDER BY  'PAUL, JOHN, PETER, MARIA' Of course, that should be all the options set Thank you. Hola a todos Existe la posibilidad de ordenar el

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

The idea is the following. Have products and services that pass through different states (order, committed, reviewed, approved, slope, bill, invoice), these may belong to a period or many (period = months). The filter may include the client query or not. La idea es la siguiente. Tengo productos

[firebird-support] CTE Recursive left join problem

Hello everyoneI'm having a problem, and I do not understand why.I have a structure similar to: with recursive  aux as (   select 0 as n     from rdb$database  union all  select aux.n + 1     from aux     where aux.n <= 20  )  select aux.n, mytable.id  from aux    LEFT JOIN mytable on aux.n

[firebird-support] SP space chacarter problem in FB2.5

Hi.in the netx SP send the follow parameters5,' ','N' --->>>5 Años (perfect) 5,'','N' --->>>5 Años ( not 5Años) without space of separation create or alter procedure VER_EDAD (     N_EDAD numeric(15,4),     SEPARADOR char(1),     CORTO char(1)) returns (     C_EDAD varchar() as begin   /*

Re: [firebird-support] SP space chacarter problem in FB2.5

Then the new SP remains: create or alter procedure VER_EDAD (     N_EDAD numeric(15,4),     SEPARADOR varchar(1),     CORTO char(1)) returns (     C_EDAD varchar(8)) as begin   /* Procedure Text */   if (separador is null) then     separador = ' ';   if (corto is null) then     corto = 'N'; 

[firebird-support] Plan problem en CTE

Hi.I have this problem in FB 2.5 with x as (SELECT *  FROM tbl_x1     JOIN tbl_fk1 ON cond_1  WHERE cond_w1UNIONSELECT *  FROM tbl_x1    JOIN tbl_fk1 ON cond_2  WHERE cond_w2) select tbl_2.pk_id  from tbl_2  where tbl_2.pk_id in (select list(x.tbl2_pk_id) from x The plan in the X table is OK,