On Sun, May 18, 2014 at 6:16 AM, [email protected] [firebird-support] < [email protected]> 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
