Performance Issue

[nikol]

I have created a report in CRXI with Dynamic & Cascading Prompts. I have used a simple view
"
SELECT a.uid,a.name
FROM table a
where date IN(SELECT max(b.date)
FROM table b
WHERE a.uid=b.uid
GROUP BY uid)
ORDER BY a.uid
on a query..
When I refreshed my report with prompt,its taking 20mins to refresh & sometimes it says CR is "NOT RESPONDING"
Is there anything in the view. Can somebdy help me.
I have just installed CRXI for new Prompt feature.Prompt is working but report stucks.

 

[ShortyA]

It could be a variety of factors. How many records are in table a and b ? If you take out the report parameter and hardcode in the record selection does that speed things up ? Finally, is it slow irrespective of the parameter used ?

ShortyA

 

[nikol]

Now, My report is taking 2 mins to refresh. For this,I have to create whole SQL qurey again in CRXI.