Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a task in my QMC which reduce and distribute data to serveral documents. The problem is that it takes almost 8 hours (it contains 50 million rows)
I think that is a long time for 50 mil rows, and i have had documents which has been faster reloaded and distributed than this.
How can i optimize?
Hi Thomas,
I would look at the document log and see what part is taking the most time. They you can look at the code for that area for an issue or an issue with the data source.
Bill
This is a difficult one to answer without more information .....
Often the cause of such problems is the SQL statement to load the data, but without more detail it is difficult to find the issue.
First of all break it down to each module or part of the process.
Once you have identified where the problem is, you should be able to ascertain what needs to be done or at the very least supply more information on what part of the process is causing an issue.
Hi, you have to separate and find the main problem
i recomend debug the document or run in desktop mode and see the time that takes you to run.
probably there is something in the reload or in the distribution that may cause a problem
good luck
Fernando