Tuesday, March 20, 2012

Save time while loading parameters value

Hello.
I have one dataset with a few parameters.
Each parameter get its available values from the some dataset.
So if I have the main DS whice is:
"select name,age,sex from table1 where age = @.age and sex = @.sex"
The available values for the parameters "age" and "sex" are those
datasets:
"select distinct age from table1" and
"select distinct sex from table1".
The problem is thet the query on table1 takes a lot of time and in
this case I need to run her three times.
Is there a way to initialize the parameters values in one query
excution and save some time?
Thanks.May not help but I have had better luck with using Group By's over
Distinct.

No comments:

Post a Comment