[Closed]Tabular reference for Performance tuning

[BIsrik]

Hi,

I have list report and query1 associated with the list. i now create a new query by query2 which contains a Tabular reference to query1. i associate a cross-tab to query2.

when i run the report...how is the execution going on. i mean there would be two sqls one for query1 and other for query2.

Is that both the sqls execute and create the report or only the sql in query1 execute and the values are copied to query2.

Srik

[sir_jeroen]

I think that q1 is executed twice... you could try local caching to relief the db server.. But try it and watch the server... Then you'll be certain...

[BIsrik]

Thats the problem i don't have the access to the server at all....Any other means of checking that...

Srik

[sir_jeroen]

you can set that in Report Studio... under query explorer...

[BIsrik]

yeah got that...use local cache for this purpose...

Srik