Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stonebreaker
Yak Posting Veteran
92 Posts |
 Posted - 2009-11-19 : 11:33:34
|
| I am running a sales report where the user drills down through several levels of multi-value parameters to pick the sales reps they want to see. It goes:Contractor Region Sales Team Sales RepWith each parameter populating based on what was chosen in the one before. They work fine, it's just that the users have complained about the lag time between parameters. What's the fastest way in general to retrieve data?Incidentally, the first three parameters all come from the same business units table in a recursive relationship.Thanks in advance.Stonebreaker |
|
|
stonebreaker
Yak Posting Veteran
92 Posts |
Posted - 2009-11-19 : 16:54:55
|
| Update: It looks like the lag time is coming somewhere between the database and the web page. Is there any way to cache a table in a web page? The base tables supplying the dropdowns are very small, 20 or 30 rows at most. |
 |
|
|
|
|
|
dependent parameters slow to populate