Click here to Skip to main content
14,325,129 members
   

C#

 
GeneralRe: Repeated join causing poor performance in for loop Pin
Mou_kol8-Apr-19 9:07
memberMou_kol8-Apr-19 9:07 
AnswerRe: Repeated join causing poor performance in for loop Pin
Luc Pattyn7-Apr-19 15:44
professionalLuc Pattyn7-Apr-19 15:44 
GeneralRe: Repeated join causing poor performance in for loop Pin
Mou_kol8-Apr-19 9:13
memberMou_kol8-Apr-19 9:13 
GeneralRe: Repeated join causing poor performance in for loop Pin
Luc Pattyn8-Apr-19 9:14
professionalLuc Pattyn8-Apr-19 9:14 
QuestionC# List: How to do 3 joins for better performance Pin
Mou_kol7-Apr-19 2:44
memberMou_kol7-Apr-19 2:44 
AnswerRe: C# List: How to do 3 joins for better performance Pin
Gerry Schmitz7-Apr-19 6:17
mveGerry Schmitz7-Apr-19 6:17 
GeneralRe: C# List: How to do 3 joins for better performance Pin
Mou_kol7-Apr-19 8:06
memberMou_kol7-Apr-19 8:06 
AnswerRe: C# List: How to do 3 joins for better performance Pin
Dave Kreskowiak7-Apr-19 6:39
mveDave Kreskowiak7-Apr-19 6:39 
Look at all the calls to Trim and ToUpper you've got on nearly every field. This causes two string operations to be performed PER FIELD ON EVERY RECORD. Those operations take time and the allocation of new memory for the results of these operations. You've added a LOT of overhead just with those operations.

If you have to "normalize" your data in the query, the design of your database needs to be looked at and modified to normalize data during INSERT, not during the query. The design of the database should be done with querying performance in mind, not just a place to store data.

GeneralRe: C# List: How to do 3 joins for better performance Pin
Mou_kol7-Apr-19 8:05
memberMou_kol7-Apr-19 8:05 
GeneralRe: C# List: How to do 3 joins for better performance Pin
Dave Kreskowiak7-Apr-19 8:29
mveDave Kreskowiak7-Apr-19 8:29 
GeneralRe: C# List: How to do 3 joins for better performance Pin
Mou_kol8-Apr-19 9:06
memberMou_kol8-Apr-19 9:06 
GeneralRe: C# List: How to do 3 joins for better performance Pin
Dave Kreskowiak8-Apr-19 9:24
mveDave Kreskowiak8-Apr-19 9:24 
AnswerRe: C# List: How to do 3 joins for better performance Pin
Mycroft Holmes7-Apr-19 12:17
memberMycroft Holmes7-Apr-19 12:17 
GeneralRe: C# List: How to do 3 joins for better performance Pin
Mou_kol8-Apr-19 9:09
memberMou_kol8-Apr-19 9:09 
QuestionHow to make code run differently depending on the platform it is running on? Pin
Xarzu5-Apr-19 6:44
memberXarzu5-Apr-19 6:44 
AnswerRe: How to make code run differently depending on the platform it is running on? Pin
Richard Deeming5-Apr-19 7:15
mveRichard Deeming5-Apr-19 7:15 
AnswerRe: How to make code run differently depending on the platform it is running on? Pin
Gerry Schmitz5-Apr-19 9:54
mveGerry Schmitz5-Apr-19 9:54 
AnswerRe: How to make code run differently depending on the platform it is running on? Pin
jschell7-Apr-19 9:00
memberjschell7-Apr-19 9:00 
Questionc# Pin
Member 142150015-Apr-19 4:29
memberMember 142150015-Apr-19 4:29 
AnswerRe: c# Pin
OriginalGriff5-Apr-19 4:39
protectorOriginalGriff5-Apr-19 4:39 
QuestionRe: c# Pin
ZurdoDev5-Apr-19 4:49
professionalZurdoDev5-Apr-19 4:49 
AnswerRe: c# Pin
Dave Kreskowiak5-Apr-19 13:03
mveDave Kreskowiak5-Apr-19 13:03 
QuestionHow to convert emoji's unicode strings Pin
Vimalsoft(Pty) Ltd4-Apr-19 20:57
professionalVimalsoft(Pty) Ltd4-Apr-19 20:57 
AnswerRe: How to convert emoji's unicode strings Pin
OriginalGriff4-Apr-19 21:35
protectorOriginalGriff4-Apr-19 21:35 
GeneralRe: How to convert emoji's unicode strings Pin
Vimalsoft(Pty) Ltd5-Apr-19 2:13
professionalVimalsoft(Pty) Ltd5-Apr-19 2:13 

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.