The latest articles on DEV Community by sainathsurender (@sainathsurender). https://dev.to/sainathsurender https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F70625%2F14b58a86-0aa9-44ef-9cd0-87f9f766439a.jpeg https://dev.to/sainathsurender en sainathsurender Tue, 26 Oct 2021 06:57:42 +0000 https://dev.to/sainathsurender/what-is-the-best-way-to-analyze-huge-chunks-of-data-in-oracle-db-4fcp https://dev.to/sainathsurender/what-is-the-best-way-to-analyze-huge-chunks-of-data-in-oracle-db-4fcp <p>We have a scenario where we need to analyze 2 lakh rows per day and based on that perform insert and update into other tables respectively. Problem is that Oracle Jobs with Parallel switched on(completely optimized) is not able to process at a faster pace and was thinking if Windows service would do that job. Wanted to know what is the right architecture for processing data from a flat table in the fastest way possible.</p>