MySQL Forums
Forum List  »  Stored Procedures

Re: Optimization of stored function overhead
Posted by: Beat Vontobel
Date: November 14, 2005 03:00PM

> I think there's something fishy with the DO
> BENCHMARK thingy...

Tanks for your clarification and your tests. I won't trust DO BENCHMARK too much from now on but test performance issues in a loop as you did.

> so I guess I have a faster machine :).

I hope you do, I ran the test on 260 MHz machine from the last century ;-) But at least the proportions were the same.

> Regarding inlining function: No, it's not done,
> and it's not an easy thing to do.

And it's not such an important thing anyway with an overhead factor of 2 to 3 instead of around 20 or more. But it could still be nice for one-liners. They could be treated as macros instead of real functions. This would for most of the part only involve some string operations, wouldn't it?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Optimization of stored function overhead
2543
November 14, 2005 03:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.