I do not show the user the entire resultset, no.
The temp database idea had crossed my mind. In fact, to keep it all in the same camp (the db server is SQL Server), I could even use SQL Express.
That would take some amount of doing, but perhaps I could use something like sync services to...