<div>
Try one of following (or all), it should help:<br />
1. Make sure you close Sql connection (connObject.Close())<br />
2. &nbsp;&lt;a href=&quot;<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en" rel="ugc">http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en</a>&quot;&gt;Download IIS 5.0 Process Recycling Tool&lt;/href&gt;<br />
3. Set limit to wp memory consumption:&lt;processModel&gt;<wbr />memoryLimi<wbr />t = 60<br />
4. Upgrading to windows 2003 will solve your problem because by default it doesn't uses aspnet_wp.<br />

</div>


Try one of following (or all), it should help:
1. Make sure you close Sql connection (connObject.Close())
2.  <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en [http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en]">Download IIS 5.0 Process Recycling Tool</href>
3. Set limit to wp memory consumption:<processModel>memoryLimit = 60
4. Upgrading to windows 2003 will solve your problem because by default it doesn't uses aspnet_wp.


<div>
the link Download IIS 5.0 Process Recycling Tool is<br />
<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en" rel="ugc">http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en</a>
</div>


the link Download IIS 5.0 Process Recycling Tool is
http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en [http://www.microsoft.com/downloads/details.aspx?FamilyID=c4ba5f3c-1eb2-4f3c-99b0-b0cde072a7d8&DisplayLang=en]

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


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?

asp.net queries and memory consumption

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.