Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amrindia
Starting Member
8 Posts |
 Posted - 2008-05-12 : 02:43:32
|
| Hi allI am having a data around 400,000 in 2 diff. tables. I am fetching all these data through an sp with diff parameter values and I am displaying in grid without pagination (client need without pagination). If i pass all parameter values I am getting all data and the system is showing correctly. But if i choose all parameters as null or 0 I should get all data without filter. this is my problem.My system is comfigured with 4 GB RAM and all others are very latest machine. When I am fetching all data without filter suddenly I am getting Out of Memory Exception. But this has been tested out in 2 GB RAM Machine. Error is coming out only in 4 GB RAM machine.Can any one help out please.MichaelRaj Arokiyasamy |
|
|
|
|
|
Urg: Out of Memory exception