Efficient Fetching Approach : collection ( criteria )

right to the point : what I mean is

if there's a Table say Task with a Status field with 3 values as : pending , inprogress , done

so to show count of all task count and status wise count of task we have to write this code currently and run the query 4 times ( fetch data 4 times )

all_task_count = Task[ID != 0].count();
pending_task = Task[Status =="pending"].count();
inprogress_task = Task[Status =="inprogress"].count();
done_task = Task[Status =="done"].count();

but if we'll fetch all the superset data in all_task collection like this

all_task = Task[ID!=0];

and then just filter the data from the all_task collection by passing the criteria in the parameter of the all_task collection like this

pending_task = all_task(Status == "pending").count();
inprogress_task = all_task(Status == "inprogress").count();
done_task = all_task(Status == "done").count();

that would reduce the 4 queries to just 1 query , and it will provide all the data of that table required with any possible criteria !

so that means it can convert Any number of queries to just 1 query i.e with query which fetches superset data ie : criteria ID != 0 if the data required is from one Parent table.

from a deluge developer point of view I think this can make the page loads more efficiently : may effect the loading speed too.

need experts feedback on this approach , what difference will it make from implementation / backend point of view.

any opinion / discussion would be greatly appreciated.

Regards
Jayesh Sonawane | zohojayesh@gmail.com