467,199 Members | 990 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

SPs from Triggers in V8.2 - Performance?


Currently, in V8.1 we have a particular trigger which causes a
significant performance impact on an inserting query (around
10seconds) which appears because the optimiser is having to recompile
the insert with the trigger body everytime a new value is inserted
(i.e not using parameter markers) - the app. status shows 'compiling'
for 10secs+

In V8.2 with the ability to call SPs from triggers - if I move the
trigger body to an SP, would it be precompiled and hence overcome this
problem completely?
or would a compile still be necessary ?

Many thanks

Nov 12 '05 #1
  • viewed: 1178
1 Reply

Everything you pushed into the preocedure would be precompiled.
However the trigger stub "CREATE TRIGGER ... CALL trigger_body(...);"
Still needs to be picked up. So there will still be "some" overhead.
You benefit directly relates to teh complexity/length of the trigger-body.

The obvious question of course is why no parameter markers are used.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jonathan Bishop | last post: by
3 posts views Thread by Artur Mucha - 96 Volt | last post: by
3 posts views Thread by 4.spam@mail.ru | last post: by
4 posts views Thread by --CELKO-- | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.