on 09-08-2011 7:49 PM
Hi,
After we applied the Multi-language, the CN25 is taking much longer to run (from 1 sec to 12 secs aprox.). That issue is making impossible our CN25 job, (we do it daily, and it's taking 36 hours!).
Does any one have any solutions, or tips that could fix this?
Thank you!!
Hi Marco,
Normally the bad performance could be caused by the volume (amount of records per execution). Could you
please reduce it? This will improve the response time.
Best regards,
Enrique
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you explain your issue in detail please?
Regards,
Gokul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Gokul,
Let me try to explain more datailed.
We created a table (CNLDST_SHORTTX) that stores the multilangue information, so we could write down information in several languages in the short text description fields.
We ran the CN25 and traced it's way, and found that it was reading the table in it's process, making it take too long (around 12 sec). Than we deactivated the multilanguage and ran the CN25 again, and it only took 1 sec to run. We don't even know why the system reads this table when runs CN25.
DO you have any idea?
Thank you!
User | Count |
---|---|
97 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.