i am executing a large query to return several thousands of rows of data. in sql query analyzer, the query runs for 3 minutes without using much memory.
i am writing an asp.net page that executes the same query in a stored procedure on the server. when i do this. aspnet_wp.exe gets huge in a hurry, and eventually crashes from too much memory usage. what can i do with asp/vb.net to not use very much RAM?