I've got a DVWP that displays data from a rather hefty SQL query. I have two controls on the page that allow the user to modify the selection.
What I would like is for the DVWP to not query until the parameters are entered via the controls. When the query runs without parameters, it takes about 30 seconds. When it runs with parameters it takes around 5-10 seconds. I can specify default parameters, but I'll still have a long initial page load and it's unlikely that data shown initially will be what the user wants to see.
Is there an easy way to accomplish this?