Desktop Grid Takes Long Time to Render

[JRO061601]

I have a report that executes in less than 1 second but takes almost 10 minutes to actually render the grid display on the Desktop. On top of that, I'm working in 3-tier mode, and I'm locked out of the Desktop while the report is rendering. 6,865 rows, 7 row attributes, 1 metric, and no column attributes, so the crosstab shouldn't be difficult. Below is the SQL. Anybody have any ideas as to why this occurs? Any solutions? Thanks.

*****

Report: Status Report
Data Rows: 6865
Data Columns: 1
Cache Used: No

Execution Start Time: 04/15/2004 08:40:50
Execution Finish Time: 04/15/2004 08:40:51

Total Duration: 0:00:00.98
SQL Duration: 0:00:00.32
Analytical Duration: 0:00:00.00
Other Processing Duration: 0:00:00.65

Number of Rows Returned: 6865
Number of Columns Returned: 8
Number of Temp Tables: 0

Total Number of Passes: 1
Number of SQL Passes: 1
Number of Analytical Passes: 0

DB User: New Database login
DB Instance: WH

Tables Accessed:
lndbf1


SQL Statements:

Pass0 - Duration: 0:00:00.32
select a11.a1orldcd a1orldcd,
a11.a1obs_nu a1obs_nu,
a11.t1lnnu t1lnnu,
a11.a1bwnm a1bwnm,
a11.a1trdt a1trdt,
a11.s1lklsdt s1lklsdt,
a11.a1ovr_ss a1ovr_ss,
sum(a11.a1orbl) WJXBFS1
from lndbf1 a11
group by a11.a1orldcd,
a11.a1obs_nu,
a11.t1lnnu,
a11.a1bwnm,
a11.a1trdt,
a11.s1lklsdt,
a11.a1ovr_ss

 

[nlim]

J,
is the same report slow in web too? If not, it's probably a desktop issue.

My guess is that it is a slow network transfer issue, but it's just a guess.

 

[chael]

Does it only happen on your machine or on all C/S Desktop installs?

 

[JRO061601]

It appears to only happen on my machine, and since I'm not fully on the client's network (not part of the domain), perhaps that is it. Thanks.

 

[chael]

maybe you need to increase the size of your page file / virtual memory.