Subject | SQL performance SS FB 3.0.1 vs SC FB 2.5.2 |
---|---|
Author | |
Post date | 2016-08-09T01:56:43Z |
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 :
==========================
select a.id,b.nm from tbl1 a, tbl2 b, tbl3 c
where a.id = b.id
and a.id = c.id
SC FB 2.5.2 is about 1.3x faster than SS FB 3.0.1.
Regards,
Anto
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 :
==========================
select a.id,b.nm from tbl1 a, tbl2 b, tbl3 c
where a.id = b.id
and a.id = c.id
SC FB 2.5.2 is about 1.3x faster than SS FB 3.0.1.
Regards,
Anto