Re: No Dynamic SQL in Function or Trigger Frustration
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?
[EDIT]
I created 4 temporary tables using ENGINE=MEMORY
Load the valid ranged data to these and loop through it without calling to HDD.
Result:
Before -> 4.4x10E+12 eliminated in 13 minutes, thats about 0,0006 % complete
After -> 7.8x10E+14 --- still a long way to go...
[END EDIT]
P.S.//
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.
Subject
Views
Written By
Posted
2776
February 27, 2014 06:47PM
1159
February 27, 2014 08:47PM
Re: No Dynamic SQL in Function or Trigger Frustration
1125
February 27, 2014 09:11PM
1098
March 14, 2014 07:43PM
1224
March 15, 2014 02:26AM
1072
March 15, 2014 10:47AM
1056
March 17, 2014 12:29AM
1040
March 17, 2014 10:38PM
1202
March 18, 2014 04:13PM
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.