Click here to Skip to main content
15,914,500 members
Home / Discussions / C#
   

C#

 
GeneralRe: Combo Box Text when working in multilingual program Pin
Luc Pattyn7-Jan-09 10:41
sitebuilderLuc Pattyn7-Jan-09 10:41 
QuestionSqlDataAdapter.Fill Pin
CodingYoshi7-Jan-09 8:37
CodingYoshi7-Jan-09 8:37 
AnswerRe: SqlDataAdapter.Fill Pin
Wendelius7-Jan-09 8:45
mentorWendelius7-Jan-09 8:45 
GeneralRe: SqlDataAdapter.Fill Pin
CodingYoshi7-Jan-09 9:51
CodingYoshi7-Jan-09 9:51 
GeneralRe: SqlDataAdapter.Fill Pin
Wendelius7-Jan-09 10:06
mentorWendelius7-Jan-09 10:06 
GeneralRe: SqlDataAdapter.Fill Pin
CodingYoshi7-Jan-09 10:22
CodingYoshi7-Jan-09 10:22 
GeneralRe: SqlDataAdapter.Fill Pin
Wendelius7-Jan-09 10:29
mentorWendelius7-Jan-09 10:29 
GeneralRe: SqlDataAdapter.Fill Pin
Dave Kreskowiak7-Jan-09 10:46
mveDave Kreskowiak7-Jan-09 10:46 
which retrieves about 3,369,957 records

You said it yourself. If your retrieving that many records, each being, say 500 bytes each, you're loading 1,684,978,500 (1.6GB!) of data into memory. Your machine is going to be swapping pages out to disk for ages!

Really, I'd go smack the guy who wrote that code. Unless you're doing something with every bit of that data, you shouldn't be retrieving that much data from the server, let alone putting it all in a DataSet/DataTable object. Besides the HUGE memory requirements, if this record count continues to grow, you'll eventually run either the server out of memory, or, more likely, the process addressable space, which is 2GB.


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008




GeneralRe: SqlDataAdapter.Fill Pin
Rutvik Dave7-Jan-09 10:15
professionalRutvik Dave7-Jan-09 10:15 
AnswerRe: SqlDataAdapter.Fill Pin
Le centriste8-Jan-09 3:37
Le centriste8-Jan-09 3:37 
QuestionC# launches another program Pin
ipstefan7-Jan-09 8:29
ipstefan7-Jan-09 8:29 
AnswerRe: C# launches another program Pin
Dave Kreskowiak7-Jan-09 10:08
mveDave Kreskowiak7-Jan-09 10:08 
AnswerRe: C# launches another program Pin
Dragonfly_Lee7-Jan-09 19:53
Dragonfly_Lee7-Jan-09 19:53 
AnswerRe: C# launches another program Pin
Pritam Karmakar7-Jan-09 21:45
Pritam Karmakar7-Jan-09 21:45 
GeneralRe: C# launches another program Pin
ipstefan8-Jan-09 0:12
ipstefan8-Jan-09 0:12 
AnswerRe: C# launches another program Pin
HosamAly8-Jan-09 0:09
HosamAly8-Jan-09 0:09 
GeneralRe: C# launches another program Pin
ipstefan8-Jan-09 0:15
ipstefan8-Jan-09 0:15 
GeneralRe: C# launches another program Pin
HosamAly8-Jan-09 5:38
HosamAly8-Jan-09 5:38 
QuestionForcina a space or suppressing zeroes in Data Grid Pin
Vanq20097-Jan-09 7:53
Vanq20097-Jan-09 7:53 
AnswerRe: Forcina a space or suppressing zeroes in Data Grid Pin
Henry Minute7-Jan-09 9:08
Henry Minute7-Jan-09 9:08 
QuestionRe: Forcina a space or suppressing zeroes in Data Grid Pin
Vanq20097-Jan-09 10:38
Vanq20097-Jan-09 10:38 
AnswerRe: Forcina a space or suppressing zeroes in Data Grid Pin
Henry Minute7-Jan-09 11:02
Henry Minute7-Jan-09 11:02 
GeneralRe: Forcina a space or suppressing zeroes in Data Grid Pin
Vanq20098-Jan-09 2:02
Vanq20098-Jan-09 2:02 
QuestionFileSystemWatcher Events Fired Twice Pin
#realJSOP7-Jan-09 5:58
professional#realJSOP7-Jan-09 5:58 
AnswerRe: FileSystemWatcher Events Fired Twice Pin
Dave Kreskowiak7-Jan-09 6:15
mveDave Kreskowiak7-Jan-09 6:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.