| Subject | FB1.5 over twice as slow as FB1.02 |
|---|---|
| Author | focusedpoint <focused1@optushome.com.au> |
| Post date | 2003-02-07T02:52:11Z |
Hi all
Running RedHat 8.0
I've been performing some speed tests on FB1.5 vs FB1.02.
On the same machine, a stored procedure chain (lots of selects and
inserts) takes 188s on FB1.02, and 486s on FB1.5
This is after recompiling all stored procedures and triggers on
FB1.5 so that it could update plans as required.
This is obviously really disappointing, are there any configuration
parameters which I should review to help 1.5 out?
Rgds
Paul
Running RedHat 8.0
I've been performing some speed tests on FB1.5 vs FB1.02.
On the same machine, a stored procedure chain (lots of selects and
inserts) takes 188s on FB1.02, and 486s on FB1.5
This is after recompiling all stored procedures and triggers on
FB1.5 so that it could update plans as required.
This is obviously really disappointing, are there any configuration
parameters which I should review to help 1.5 out?
Rgds
Paul