MySQL Forums
Forum List  »  Stored Procedures

Re: No Dynamic SQL in Function or Trigger Frustration
Posted by: Mike Jonsson
Date: February 27, 2014 09:11PM

That would be impossible to implement in the app as MySQL "is" (per definition) "the App" in this case.

To jump between C, C#, VB, PHP, Python or anything else to do this would increase runtime to anywhere in the #Nth millions of years to run til completion.

This really needs to finish in a matter of hours of run-time tops.

So 2 follow-up questions to my initial two questions would be;

1. How difficult is it to re-write a local version of MySQL from source to actually permit this feature to function?

2. What would the security caveats be since something originally prevented the developers of MySQL from putting the functionality into the source from the start?


I created 4 temporary tables using ENGINE=MEMORY

Load the valid ranged data to these and loop through it without calling to HDD.


Before -> 4.4x10E+12 eliminated in 13 minutes, thats about 0,0006 % complete

After -> 7.8x10E+14 --- still a long way to go...



MySQL on my PC (Win 7, AMD 4core and 4 GB DDR-3 managed to run approx. 1.45x10e14 + rows with all calls, counts and checks over a period of 4 hours...

You see why speed is of the essence!

// D.S.

Options: ReplyQuote

Written By
Re: No Dynamic SQL in Function or Trigger Frustration
February 27, 2014 09:11PM

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.