Script takes more time to execute in server

[qv_jagan]

Hello,

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.

Thanks,

Jagan. V