Extraction process is taking long time
We are using 0fi_gl_14 DS in our process chain and sceduled it in every 2 hrs, Previously it is working fine. But now it is taking too long time to run extraction process (job) in r/3 side and for extracting 3 records it is taking 2 to 3 hrs and it is overlapping with the next schedule.
Could you please let me know what might be the reason, and how to improve the performance?.
Edited by: harishhh on Jul 12, 2011 8:59 AM
Are there any Index created for this data source in ECC.Creating INdex will help you in this situation .Take the base tables for this data sources and create Index on those Tables .