Subject | FB 2.0 / FB1.5 optimizer difference |
---|---|
Author | Hans |
Post date | 2006-12-04T00:06:34Z |
Hello,
I carefully converted a long time running a FB1.5 application to FB2.0, took
care of
the differences of the 'not in' instances. But I experience just a few
queries execute
faster, but most execute are 2 to 40 times slower. Most even showing the
same plans
as FB1.5. Database characteristics the same. Database only about 500M in
size.
What else can I present, do or to assist ?
Best Regards
Hans
I carefully converted a long time running a FB1.5 application to FB2.0, took
care of
the differences of the 'not in' instances. But I experience just a few
queries execute
faster, but most execute are 2 to 40 times slower. Most even showing the
same plans
as FB1.5. Database characteristics the same. Database only about 500M in
size.
What else can I present, do or to assist ?
Best Regards
Hans