Re: [firebird-support] Alternative to MySQL ELT() function ?

Karol, thanks a lot !!!

[firebird-support] Alternative to MySQL ELT() function ?

As the tithe says, is there anything similar to MySQL ELT() function in Firebird ? Regards, Zoran

[firebird-support] Re: Firebird performance vs PostgreSQL

Hi, database structures at: https://paste.ee/p/qjTwz https://paste.ee/p/qjTwz Aprox size of tables Artikli = 227.000 rows faktur = 85.000 rows izlaz = 292.000 rows Partneri = 13400 rows Kurs = 180 rows Vrste = 560 rows Porezi = 6 rows Faktype = 30 rows Magacin = 60 rows Query SELECT

[firebird-support] Firebird performance vs PostgreSQL

Hello community, I am Firebird user for many years, I think I started using Interbase in 2001, and after that I use Firebird from version 1.0. I have a Firebird 2.5 Server in the company where I work, which stores some data for the purpose of business analysis. Since now it is September, many

Re: [firebird-support] Import - slower and slower commits

no triggers, no indexes on the table.

[firebird-support] Import - slower and slower commits

Hi Group, I have a huge table to import - tens millions of rows. From my experience, it is not good practice to commit job after importing everything, because import of rows can become slower and slower. So, i decided to make commit after every 50.000 rows. So far so good. Now I am at

Re: [firebird-support] Import - slower and slower commits

Aleksey, What I did is: Stopped firebird 2.5.3 server Renamed bin folder to bin orig copied BIN folder from zip file I downloaded (snapshot 2.5.4) started firebird server Checked server vesrion - it says 2.5.4.26842 Continuing import after 72.000.000 rows, now I get folowing timings: 100.000

Re: [firebird-support] Import - slower and slower commits

Hi Aleksey, Thanks for the reply. Should I just uninstall, install other version, or I should aslo do backup / restore ? regards, Zoran

[firebird-support] Know nothing - please help

I have a query like this: select artikli.a_sif, v1.v_txt, v2.v_txt, coalesce(sum(magkol.k_total),0) total, coalesce(sum(magkol.k_nabcen * magkol.k_total),0) vrednost, coalesce(sum(magkol.k_nabcen * magkol.k_total),0)/ coalesce(sum(magkol.k_total),1) nc,

RE: [firebird-support] Know nothing - please help

Perfect! Thank you very much. Regards, Zoran

Re: Odp: [firebird-support] Re: Speed issues

Thanks Sean for all your comments. Zoran

RE: [firebird-support] Re: Speed issues

I am doing restore now with 8192 page value, but I will not know before tomorrow. It will not be finishen in next 90 minutes, and I all be sleeping until tehn, probably. Thanks for your advices - I will advice tomorow about changes. Also, what do you think - when I put it on working server -

Re: Odp: [firebird-support] Big database optimizatio n

I believe it is Superserver (how can I say exactly?) 2.5.2 64 bit on win7 64 bit. Cache setings for database are at the moment Pages 16384 = 65536 KB, I tried different aproaches, with smaller and bigger pages - but I didnt resolve issue. Regards, Zoran

RE: [firebird-support] Big database optimization

select distinct art_id, art_article_nr, COALESCE(art_tex.tex_text, art_tex_uni.tex_text) articledes, ga_id, ga_tex.tex_text gades, ga_tex.tex_text||' ('||ga_assembly_tex.tex_text||')' ga_assembly, la_id, lat_sort sort, lat_sup_id bra_id, COALESCE(sup_cou.sup_brand, sup_null.sup_brand)

[firebird-support] Big database optimization

I am runing WI-V2.5.2.26539 Firebird 2.5, on win 7 64 bit. Databse is more than 20 GB big, and I have tables which are really huge - millions of rows. My query combines 6-7 tables, and all tables are searched with use of indexes, so altough tables are huge, query fethes only 10.000 rows, for

[firebird-support] Left outer join with stored procedure

Hello All, I have a table regioni with 164 rows (r_id), and also stored procedure which returns some data like (r_id, value). When I try to use select regioni _ID, stored_procedure_value from regioni left outer join stored_procedure (:DATE1,:DATE2) I only get number 20 rows for the R_ID