Unbearably slow query and batch job
whatever big name/new star
Why the running speed is so low now?
When the hardware remains unchanged, you have to design the algorithms featuring less computation amount,
and then code in an effective programming language.
Unfortunately, you cannot implement such low-complexity algorithms in SQL due to its theoretical limitation.
Then, how can I make the running speed fast?
Well, discard SQL.
Also, you should not use Java as well. Although you can implement the said algorithms in Java, it will make you exhausted.
Using SPL instead, it will allow you to implement high-performance computing with simple code.
What is SPL? Why does it work?
SPL is an open-source programming language, specializing in dealing with structured data computation. We’ve integrated dozens of high-performance algorithms and storage schemes in SPL, which make it a reality to speed up by N times!
Want to learn it? Visit: Performance Optimization, SPL Tutorial
Is it really that amazing?
Check out the performance optimization algorithms that can be implemented in SPL but can't in SQL:
Looks good, does it really work?
Take a look at these cases, and calculate by yourself to see how many times the speed is increased:
Can I have a try?
Sure, just a few steps:
i, provide related information;
ii, discuss in detail and do a few tests;
iii, design optimization plan.