system out of memory exception

[devathi]

hi,
In my application I have to populate a grid with 10000 records at a time.So when multiple users open the screen and try to retrieve the data,the IIS server is unable to hold the huge amount of data and its throwing system out of memory(cache memory) exception.
Front end of the application is :ASP.Net using VB
Back End is Sybase.Please let me know if u have any solution to this problem.thank u.

[sashi]

hi,
In my application I have to populate a grid with 10000 records at a time.So when multiple users open the screen and try to retrieve the data,the IIS server is unable to hold the huge amount of data and its throwing system out of memory(cache memory) exception.
Front end of the application is :ASP.Net using VB
Back End is Sybase.Please let me know if u have any solution to this problem.thank u.

Hi there,

You can try to increase the script timeout properties. Another option will be increasing the cache (paging) memory, hope it helps. Good luck & Take care.

[devathi]

hi,
Can u please elaborate on the solution, how to increase the cache memory.I am not getting what do u mean by script time out properties?

[sashi]

hi,
Can u please elaborate on the solution, how to increase the cache memory.I am not getting what do u mean by script time out properties?

Which OS are you currently working on? Kindly follow steps below to change cache (pagefile) size,

Desktop > MyComputer > Right Click > Select Properties > System Properties Dialog Box > Select Advance Tab > Click on Performance Options > Performance Dialog Box > Click on Change button> Now you should be able to change the Initial size & Maximum size values accordingly.

Since you are working on ASP.NET add the below line of code right before your query part begins, hope it helps. Good luck & Take care.

<% Server.ScriptTimeout = "change_this part_to_whatever_value_in_second(s)" %>
 

[devathi]

Suggest solution for increasing the cache size in Windows 2003 professional.

[sashi]

Suggest solution for increasing the cache size in Windows 2003 professional.

Hi there,

Am not sure about doing it in Windows 2003, anyway, try the below method, hope it works. Good luck & Take care.

Desktop > MyComputer > Right Click > Select Properties > System Properties Dialog Box > Select Advance Tab > Click on Performance Options > Performance Dialog Box > Click on Change button> Now you should be able to change the Initial size & Maximum size values accordingly.