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 |
|
Yucky
Starting Member
2 Posts |
 Posted - 2005-03-03 : 18:04:19
|
| Hi,I'm having an sql 2000 table with more than 26,000 records. I want to bind all those data to a datagrid with paging on pageload but error occurred because the data is too big. How can I handle this situation?I got this message from the event log"aspnet_wp.exe (PID: 1536) was recycled because memory consumption exceeded the 612 MB (60 percent of available RAM)."Thank you so much. |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-03-03 : 18:38:35
|
| Well, it sounds like you can't do this.You'll need to page the data, use a datarepeater, or dump the data to a report.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-03-03 : 20:53:18
|
| Can you not see the problem with binding 26000 records to a webpage ?Even if they are not displayed, the 26000 records are being serialized in your viewstate. You are putting an unnecessary, and totally pointless load on your aspnet_wp, your database AND your end users browser. It's just silly.Do your paging inside a stored proc instead.Damian |
|
|
|
|
|
|
What's the best way to bind huge data?