| Subject | Re: [firebird-support] Re: Firebird fast on one machine (2 seconds) - slow on another (> 2 hours) |
|---|---|
| Author | Anderson Farias |
| Post date | 2011-01-21T21:06:39Z |
Hi,
|
|I don't understand what you are asking for "actual PLANs for each case?"
|
Each statement has an execution PLAN that tells what "path" the engine takes to get the desired records.
If you can narrow WHAT is the 'problematic' statements your app is running and then execute them using some client like ISQL or FLAME ROBIN, you'll get to know the execution plan and statistics from the engine.
That information may help finding what's going wrong.
As an alternative, and very easy way to find your what's wrong, is enabling fb AUDIT (or start a trace session) -- since you're rinning fb 2.5 -- and run your application. Than Fb you show you whats going on!
=)
Regards,
Anderson
|
|I don't understand what you are asking for "actual PLANs for each case?"
|
Each statement has an execution PLAN that tells what "path" the engine takes to get the desired records.
If you can narrow WHAT is the 'problematic' statements your app is running and then execute them using some client like ISQL or FLAME ROBIN, you'll get to know the execution plan and statistics from the engine.
That information may help finding what's going wrong.
As an alternative, and very easy way to find your what's wrong, is enabling fb AUDIT (or start a trace session) -- since you're rinning fb 2.5 -- and run your application. Than Fb you show you whats going on!
=)
Regards,
Anderson