Desktop: Qlikview Enterprise Edition 10 SR1
Server: Qlikview 11
I developed an application using Qlikview 10 SR1 which less than 3 mins to reload.
When I deployed in Qlikview server 11 it takes more than 6 mins to reload.
Could some one please let me know why it happens like this?
I also generated the log file, the log file shows thaat after fetching data from first qvd it waits for a long time and goes for second qvd.
First QVD START Time: 19/10/2012 08:11:25
First QVD END Time: 19/10/2012 08:11:25
SECOND QVD START TIME: 19/10/2012 08:16:52
SECOND QVD END TIME: 19/10/2012 08:16:52
THIRD QVD START TIME: 19/10/2012 08:17:24
THIRD QVD END TIME: 19/10/2012 08:17:30
All the 3 QVD's are autoconcatenated by qlikview.
I use the following functions given belwo inside all the 3 QVD's
date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY') as monthdate,
date(floor(MonthEnd(date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY')))) as date,
FLOOR(num(MonthEnd(date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY')))) as date1,
Please let me know the issue.
Also when the task is run in server, the performance of server goes to 100% usage.
Please let me know what should I have to do.