Subject | UDF's vs Stored Procedures |
---|---|
Author | Ian Newby |
Post date | 2001-06-28T09:34:54Z |
Hi All,
I am about to start writing an expression parser for use in interbase
to allow user defined calculations to take place in a trigger. My
options at the moment are to write an expression parser UDF, or to write
a series of stored procedures which will do the same thing. (The
procedures will need to access SUBSTR and STRLEN udfs.)
Has anyone any information on the relative speed of UDF's verses
stored procedures? Which one would be best in this instance.
Regards
Ian Newby.
I am about to start writing an expression parser for use in interbase
to allow user defined calculations to take place in a trigger. My
options at the moment are to write an expression parser UDF, or to write
a series of stored procedures which will do the same thing. (The
procedures will need to access SUBSTR and STRLEN udfs.)
Has anyone any information on the relative speed of UDF's verses
stored procedures? Which one would be best in this instance.
Regards
Ian Newby.