I have Java project and problem is that one report generation runs about 5 mins
I looked to logs and i see that same query runs about 500 time and takes about 1s each time = 8 mins
I know there this query exist and need to change way it runs:
a) load 1 time results to memory and do not query each time to database
b) find and change code there invoke exist
c) your suggestions
Query place - [url removed, login to view]
If you read description write HelloYello
20 freelancers están ofertando el promedio de €145 para este trabajo
hello yello Hello Sir.. I read your description I am fully confident that I can do that also I am available to start work right now. I am waiting for your response thank you much.
I am a full time Java and database developer. Query and code for results caching is what I do. I would need access to the code and data, I don't mind how that is done.