speeding up select query using parallel processing
Multi tool use
Clash Royale CLAN TAG#URR8PPPspeeding up select query using parallel processing
I am running a simple select query to fetch all the values from the table and writing the resultset into CSV file using Java code. My select query is similar to below
select * from <tablename>
This table contains data for the past 3 years. One of the ways that I was thinking of speeding up the process is to run a separate thread thereby spinning up 36 threads , each querying 1 month worth of data ( after making sure db can handle 36 connections) and aggregating the result into a single file.
Is there any library within java or oracle function that helps in achieving the same by querying the data in parallel and aggregating the result set.
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
