asp.net - Dealing with huge amount of select statements -

i'm designing asp.net application wich builds overview of sales per partner in period of time. how works far:

1. select partnerno(sql-server) , add list(asp.net)
2. select sales of partnerno1 on period of time(sql-server), summarize them(asp.net) , add them datatable(asp.net)
3. select sales of partnerno2 on period of time, summarize them , add them datatable
4. select sales of partnerno3 on period of time, summarize them , add them datatable

and on

now here problem: if select top 100 partnerno, if takes while, result. if change top 1000, sql-server processes sql-statements (can see him working in activitymonitor), , iis-server feeding him new sql-selects... after while, iis terminating page-request browser, no result shown

i hope, explain enough me.

with regards

dirk th.

that's rbar anti-pattern. should possible create 1 sql query returns summarized information partners.

that's typically faster: less data has go on line, , less often. roundtrip database can cost 50ms. if 600 of those, you're @ 30 second timeout web pages.