RE: [firebird-support] SQL performance SS FB 3.0.1 vs SC FB 2.5.2

2016-08-09 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> Just found that on a particular case, SS FB 3.0.1 is about 4x slower than SC > FB > 2.5.2. > > Here is the query : > == > select a.id,b.nm from tbl1 a, tbl2 b > where a.id = b.id > and a.id in (select c.id from tbl3 c) > > If the query change to this : > =

[firebird-support] SQL performance SS FB 3.0.1 vs SC FB 2.5.2

2016-08-08 Thread trsk...@yahoo.com [firebird-support]
Hi guys, Just found that on a particular case, SS FB 3.0.1 is about 4x slower than SC FB 2.5.2. Here is the query : == select a.id,b.nm from tbl1 a, tbl2 b where a.id = b.id and a.id in (select c.id from tbl3 c) If the query change to this : ==