Hi all,
Just migrating from SC FB 2.5.2 to SS FB 3.0 (both in Win x64), i found a few problems :
1) Query that runs about 2-3 secs in SC FB 2.5.2, runs minutes in SS FB 3.0
Query is something like this :
Select a.col1,b.col1 from tbl1 a, tbl2 b where a.id = b.id and b.id in (select c.id from tbl3 c)
SS FB 3.0 uses different query plan that not use indices, no wonder it was so slow.
Changed query to :
Select a.col1,b.col1 from tbl1 a, tbl2 b, tbl3 c where a.id = b.id and b.id= c.id
Runs around 1-2 secs in SS FB 3.0, but runs minutes in SC FB 2.5.2
2) Since in FB 3.0, SS is able to use SMP & shared Db Cache, I tried to set Db Cache to 512 MB via gfix. It was without error.
First connection is OK & I could saw that the actual Db cache size is around 300 MB. But after connection closed & tried to connect again, FB raised an error, something like connection lost.
Changed Db Cache to 256 MB fixed th e problem. I think, for modern computer, 256 MB is too small.
Regards,
Anto.
Posted by: <liviuslivius@poczta.onet.pl>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment