[firebird-support] Re: Firebird performance vs PostgreSQL

29.09.2017 01:08, Ertan Küçükoğlu wrote: Answers can be found in the plans: > PLAN JOIN (RAPOR_EK ORDER rapor_ek_pkey, SORT (DT M NATURAL)) This join plan is terrible for FB. Are KAYNAGAGORE and SEBEBEGORE indexed? They seem not. > Merge Left Join (cost=6600.19..6610.98 rows=560 width=340)

[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

RE: [firebird-support] Firebird performance vs PostgreSQL

> From: mailto:firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: Thursday, September 28, 2017 7:35 PM > To: mailto:firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Firebird performance vs PostgreSQL > > > Hi, > > without any sample you

RE: [firebird-support] Firebird performance vs PostgreSQL

> From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: Thursday, September 28, 2017 7:35 PM > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Firebird performance vs PostgreSQL > > > Hi, > > without any sample you talking about

Re: [firebird-support] Find duplicate multi-row entries

Sorry again, Daniel, I had to get to a place where I could test things before replying. My problem was that what I'd done before was to try to find identical sets, not trying to find unique sets, and that made me mess up the logic. I hope this query will get you what you want (and this time

RE: [firebird-support] Re: Collation with Numeric-Sort and index

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Friday, September 22, 2017 9:06 AM Did you have a setup (version of FB and ICU) that passes these tests? No, I have not been able to find a config that works. Tested

Re: [firebird-support] Firebird performance vs PostgreSQL

Hi, without any sample you talking about nothing.. Show some sample which can be reproduced. Without this i can say same Firebird is faster then Oracle and what someone can say about this – nothing regards, Karol Bieniaszewski From: zilez2...@yahoo.com [firebird-support] Sent: Thursday,

Re: [firebird-support] LIST gives inconsistent results

On 2017-09-28 16:40, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > But that doesn't make sense. Right from the docs you quoted - "If > ordering is important, It is no guarantee as documented: "The ordering of the list values is **undefined**—the order in which the strings are

Re[2]: [firebird-support] LIST gives inconsistent results

But that doesn't make sense. Right from the docs you quoted - "If ordering is important, the source data can be pre-sorted using a derived table or similar." So if I create the derived table using ORDER BY - why is the LIST not sorted? But...if somehow the join is messing up the LIST

RE: [firebird-support] Re: FB 3.0 Replacing ICU libraries

Hi Dany, Do you mind sharing which character set you use and how your collation is defined? Mvh Magnus Johansson

Re: [firebird-support] LIST gives inconsistent results

On 2017-09-28 10:49, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > It's certainly possible my database is corrupted - I don't think it > is. But I'm willing to test if someone tells me how. However... > > At the moment, after several painful hours, I think I've determined > the

Re: [firebird-support] Embedded FB3 was killed?

28.09.2017 12:25, Matthias Hanft m...@hanft.de [firebird-support] wrote: > As far as I understand that, I just call "fbclient.dll" as usual, > and if the database path is a local file, "fbclient.dll" automagically > calls "engine12.dll" (or whatever it needs) for the use as a local/ > embedded

Re: [firebird-support] Embedded FB3 was killed?

Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > >Read carefully "Remodelled Architecture" part. As far as I understand that, I just call "fbclient.dll" as usual, and if the database path is a local file, "fbclient.dll" automagically calls "engine12.dll" (or whatever it

Re: Re[4]: [firebird-support] Find duplicate multi-row entries

OK, that's completely different, but I've done something similar once before. It is not possible to directly compare sets for equality, but it is possible to check that set A doesn't contain anything that isn't in set B and that set B doesn't contain anything that isn't in set A. I assume NODE is

[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[6]: [firebird-support] Find duplicate multi-row entries

This appears no different than a simple: select * from routes So...not there yet. I think what I'm fighting is the lack of pivot or crosstab functionality - and I may have no choice (though it offends me deeply) but to setup my archive table for this comparison. Either via the hated

Re: Re[4]: [firebird-support] Find duplicate multi-row entries

Sorry again, Daniel, fourth query required (I forgot that things may vary depending on time, this is something I've never done before): with tmp(NODE, ROUTE_UPDATED) as (select distinct rh.NODE, rh.ROUTE_UPDATED from route_history rh join routes r on rh.NODE = r.NODE), //*This join is only for

[firebird-support] LIST gives inconsistent results

It's certainly possible my database is corrupted - I don't think it is. But I'm willing to test if someone tells me how. However... At the moment, after several painful hours, I think I've determined the following: CREATE TABLE NODES ( NODE smallint NOT NULL, ROUTE_UPDATED timestamp,

Re: [firebird-support] Multiple LIST columns

I found a far more elegant? way to accomplish this - concatenate the fields with a single LIST, e.g. select n.NODE, h.ROUTE_UPDATED, list( h.ROUTE_INDEX || h.LINK_NODE || h.QUALITY ) from NODES n join ROUTE_HISTORY h on n.NODE=h.NODE where n.NODE=5104 group by n.NODE, h.ROUTE_UPDATED order

Re: Re[4]: [firebird-support] Find duplicate multi-row entries

Sorry, I forgot that should probably use 'IS NOT DISTINCT' and not '=' for QUALITY. Note that this checks only checks if there has ever been anything identical in ROUTE_HISTORY, it doesn't restrain itself to the latest entry only (i.e. the query I've written is slightly similar to the second

Re[4]: [firebird-support] Find duplicate multi-row entries

Thanks - but that still doesn't work. I get a huge return set with a ton of duplicates. I think something's being lost in translation. A simple match of one row isn't sufficient - I need to match the "set". With the following six records: 5557111160 5557211150 5557

Re: Re[2]: [firebird-support] Find duplicate multi-row entries

Sure it is possible to write such a query: select r.NODE, r.ROUTE_INDEX, r.LINK_NODE, r.QUALITY from routes r left join route_history rh1 on r.node = rh1.node and r.route_index = rh1.route_index and r.link_node = rh1.link_node

Re: Re[2]: [firebird-support] Find duplicate multi-row entries

Please define "set" Regards,Karol Bieniaszewski null