On Sun, May 18, 2014 at 6:16 AM, lafras@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

4) SQL statements run as byte code in a “virtual machine” and are just as as speed efficient(if not more so) at data and sting manipulation (Casting, concatenation, substing and replace) than other byte coded languages such as java, python etc.

Regards,

Lafras

For #4 we had a stored procedure that did some string manipulation and calculation routines that was called many times by other stored procedures and triggers.  We moved it out to a UDF written in C and saw a large performance increase.

-steve

--
Steve Wiser
President
Specialized Business Software
6325 Cochran Road, Unit 1
Solon, OH 44139

www.specializedbusinesssoftware.com
www.docunym.com
(440) 542-9145 - fax (440) 542-9143
Toll Free: (866) 328-4936