Filter - WebSite

[Danilo]

Hi,

I'd like to know if there's anyone who knows what kind of model/architecture
is used to do filters like this site:
http://www.circuitcity.com/ccd/category.do?catOid=-16941&N=20013061+20016941&c=1

They have categories (top menu), this is ok, normal. But, the left side menu
has another kind of filters, which modifies according to what the user's
choice.
And more: each filter has its own count.
I.e.: 1 to 2 mpx (30) -> it means: cameras from 1 to 2 megapixels - 30
models.

I have a database/asp page model that does that, but the performance is not
so good. I'm sure that the model used by them is different.
Even using Sql Server, Stored Procedures...

So, anyone has any idea?

Thanks!

Danilo

 

[DM]

for faster performance, you do this type of thing on a server built for high
traffic access and only for the database serving (no other applications).
most companies with this type of frame work use scrips to talk to a sql or
php server.