| Subject | RE: [firebird-support] Recompiling Triggers and Procedures? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-08-07T23:43:54Z |
At 01:36 PM 7/08/2004 -0700, you wrote:
module. The effect will be on optimisation, and optimisation occurs at
run-time, not when the module is compiled.
That said, as part of a tuning exercise, you might *want* to visit a
module's source and see whether some recoding of queries within will
improve performance. Because index usage for PSQL modules occurs on
SELECTS inside the module, you may well want to explore a better way to
extract data inside a module.
/heLen
>I'm assuming you would have a performance increase if you added indicesAdding indexes after compiling a SP or trigger module won't affect the
>after creating the stored procedure or trigger that they could take
>advantage of. Otherwise nothing?
module. The effect will be on optimisation, and optimisation occurs at
run-time, not when the module is compiled.
That said, as part of a tuning exercise, you might *want* to visit a
module's source and see whether some recoding of queries within will
improve performance. Because index usage for PSQL modules occurs on
SELECTS inside the module, you may well want to explore a better way to
extract data inside a module.
/heLen