Click here to Skip to main content
15,886,110 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: changing default namespaces Pin
CalvinHobbies8-Mar-10 5:14
CalvinHobbies8-Mar-10 5:14 
QuestionGetting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Paul Brower6-Mar-10 2:41
Paul Brower6-Mar-10 2:41 
AnswerRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Eddy Vluggen6-Mar-10 4:04
professionalEddy Vluggen6-Mar-10 4:04 
GeneralRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Paul Brower6-Mar-10 4:59
Paul Brower6-Mar-10 4:59 
GeneralRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Eddy Vluggen6-Mar-10 5:06
professionalEddy Vluggen6-Mar-10 5:06 
GeneralRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Paul Brower6-Mar-10 8:47
Paul Brower6-Mar-10 8:47 
GeneralRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Eddy Vluggen6-Mar-10 8:57
professionalEddy Vluggen6-Mar-10 8:57 
GeneralRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Paul Brower6-Mar-10 9:49
Paul Brower6-Mar-10 9:49 
SOOOO embarrassed about this, but I feel like I must post, so as not to further dissuade anyone from using MySql.

As it turns out, the code the was executing in production, somehow (um, me) was double-building an inner join.

So, instead of something like this:

select s.id, s.tag, s.gline, s.sex, bdCal.yyyymmdd as birth_date
from weaner_83 s inner join calendar bdCal on bdCal.dddd=s.birthdate
where id in ('X05008869E1G7','X05028869E1G7')

I was getting this:

select s.id, s.tag, s.gline, s.sex, bdCal.yyyymmdd as birth_date
from weaner_83 s inner join calendar inner join calendar bdCal on bdCal.dddd=s.birthdate
where id in ('X05008869E1G7','X05028869E1G7')

These ids can only exist once in the table. With these two Id's, i was getting 380,000 records. Why, you ask? about 190,000 records in the table, and 10,000 in the calendar table.

Of course my actual code was query much more than just these two id's.

I'll probably never know how this happened, but most assuredly it's my fault. Now it's fixed, and i've burned a good 8 hours.

Thanks for you willingness to help.
GeneralRe: Getting OutOfMemory error in 3.5 Windows app after upgrading server memory Pin
Eddy Vluggen6-Mar-10 10:29
professionalEddy Vluggen6-Mar-10 10:29 
QuestionCompact Framework vs Normal Framwork Pin
Anubhava Dimri5-Mar-10 22:14
Anubhava Dimri5-Mar-10 22:14 
AnswerRe: Compact Framework vs Normal Framwork Pin
Eddy Vluggen6-Mar-10 1:15
professionalEddy Vluggen6-Mar-10 1:15 
QuestionWindowsFormsHost invalid theme in WPF Application (.Net 3.5) Pin
Mehdi Ghiasi4-Mar-10 9:07
Mehdi Ghiasi4-Mar-10 9:07 
AnswerRe: WindowsFormsHost invalid theme in WPF Application (.Net 3.5) Pin
Dave Kreskowiak4-Mar-10 9:13
mveDave Kreskowiak4-Mar-10 9:13 
Questionvb.net, check array elements? Pin
golisarmi4-Mar-10 5:33
golisarmi4-Mar-10 5:33 
AnswerRe: vb.net, check array elements? Pin
Not Active4-Mar-10 5:40
mentorNot Active4-Mar-10 5:40 
GeneralRe: vb.net, check array elements? Pin
golisarmi4-Mar-10 5:50
golisarmi4-Mar-10 5:50 
GeneralRe: vb.net, check array elements? Pin
Not Active4-Mar-10 5:54
mentorNot Active4-Mar-10 5:54 
GeneralRe: vb.net, check array elements? Pin
golisarmi4-Mar-10 6:04
golisarmi4-Mar-10 6:04 
GeneralRe: vb.net, check array elements? Pin
Not Active4-Mar-10 6:15
mentorNot Active4-Mar-10 6:15 
GeneralRe: vb.net, check array elements? Pin
Gideon Engelberth4-Mar-10 6:10
Gideon Engelberth4-Mar-10 6:10 
GeneralRe: vb.net, check array elements? Pin
golisarmi4-Mar-10 6:25
golisarmi4-Mar-10 6:25 
GeneralRe: vb.net, check array elements? Pin
RugbyLeague4-Mar-10 23:28
RugbyLeague4-Mar-10 23:28 
GeneralRe: vb.net, check array elements? Pin
Dhyanga9-Mar-10 10:00
Dhyanga9-Mar-10 10:00 
QuestionSending E-mail through default settings Pin
Jack Vanderhorst4-Mar-10 3:38
Jack Vanderhorst4-Mar-10 3:38 
AnswerRe: Sending E-mail through default settings Pin
Luc Pattyn4-Mar-10 4:15
sitebuilderLuc Pattyn4-Mar-10 4: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.