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.
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)