Hi,

Check out http://www.landwatch.com/Land_For_Sale

Notice the filters on the left colum and how they all have the count of the entries within them. I am sure they are not calculating all these count at the run-time. They have these values stored somewhere and just retrieving the top 5 values. Not sure how this can be done. Any insight?

I hear that datacubes with all these dimensions can give this result instantaneously. But I'd like to think there's an easier solution.

Help!

That's basically one of the the purposes of using a database! So you can extract such things as counts of entries etc.

basic SQL would be ->

SELECT COUNT(column) FROM table WHERE criterea = value;