Click here to Skip to main content
14,984,043 members
Home / Discussions / C#
   

C#

 
GeneralRe: Igroupping with Parallel Pin
Dave Kreskowiak1-Mar-20 7:50
mveDave Kreskowiak1-Mar-20 7:50 
GeneralRe: Igroupping with Parallel Pin
Member 110035101-Mar-20 18:28
MemberMember 110035101-Mar-20 18:28 
AnswerRe: Igroupping with Parallel Pin
Luc Pattyn1-Mar-20 9:04
sitebuilderLuc Pattyn1-Mar-20 9:04 
GeneralRe: Igroupping with Parallel Pin
Member 110035101-Mar-20 18:36
MemberMember 110035101-Mar-20 18:36 
GeneralRe: Igroupping with Parallel Pin
Pete O'Hanlon1-Mar-20 21:21
mvePete O'Hanlon1-Mar-20 21:21 
GeneralRe: Igroupping with Parallel Pin
Member 110035101-Mar-20 22:17
MemberMember 110035101-Mar-20 22:17 
GeneralRe: Igroupping with Parallel Pin
Pete O'Hanlon1-Mar-20 22:42
mvePete O'Hanlon1-Mar-20 22:42 
GeneralRe: Igroupping with Parallel Pin
Richard Deeming1-Mar-20 23:57
mveRichard Deeming1-Mar-20 23:57 
You'd obviously need to measure which part was slow. But I'd suspect that:
where tb .Date.Year == chunks
would be translated to:
WHERE DatePart(year, [Date]) = @year
which is not SARGable[^].

Try changing the parallel query to something like:
lstFilters.AsParallel().ForAll(year =>
{
    DateTime minDateInclusive = new DateTime(year, 1, 1);
    DateTime maxDateExclusive = minDateInclusive.AddYears(1);
    
    using (var dbLinq2 = NewDBInstance(dbSource))
    {
        var lstRecords = (from tb in dbLinq2.Table
                          where tb.Date >= minDateInclusive && tb.Date < maxDateExclusive
                          select tb).ToList();




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Generaladd DISTINCT drop PARALLEL Pin
Luc Pattyn2-Mar-20 0:48
sitebuilderLuc Pattyn2-Mar-20 0:48 
Generaldrop TOLIST, avoid memory stress Pin
Luc Pattyn2-Mar-20 9:13
sitebuilderLuc Pattyn2-Mar-20 9:13 
AnswerRe: Igroupping with Parallel Pin
Eddy Vluggen1-Mar-20 13:47
professionalEddy Vluggen1-Mar-20 13:47 
GeneralRe: Igroupping with Parallel Pin
Member 110035101-Mar-20 22:18
MemberMember 110035101-Mar-20 22:18 
QuestionError must declare scalar variable @ISBN update statement c# Pin
Member 1164145429-Feb-20 5:20
MemberMember 1164145429-Feb-20 5:20 
AnswerRe: Error must declare scalar variable @ISBN update statement c# Pin
OriginalGriff29-Feb-20 5:38
mveOriginalGriff29-Feb-20 5:38 
GeneralRe: Error must declare scalar variable @ISBN update statement c# Pin
Member 1164145429-Feb-20 22:20
MemberMember 1164145429-Feb-20 22:20 
GeneralRe: Error must declare scalar variable @ISBN update statement c# Pin
OriginalGriff29-Feb-20 22:42
mveOriginalGriff29-Feb-20 22:42 
GeneralRe: Error must declare scalar variable @ISBN update statement c# Pin
phil.o29-Feb-20 22:44
mvephil.o29-Feb-20 22:44 
QuestionESENTUTL in C# Pin
colins528629-Feb-20 4:28
Membercolins528629-Feb-20 4:28 
AnswerRe: ESENTUTL in C# Pin
OriginalGriff29-Feb-20 5:40
mveOriginalGriff29-Feb-20 5:40 
AnswerRe: ESENTUTL in C# Pin
Luc Pattyn29-Feb-20 9:27
sitebuilderLuc Pattyn29-Feb-20 9:27 
AnswerRe: ESENTUTL in C# Pin
Dave Kreskowiak29-Feb-20 10:38
mveDave Kreskowiak29-Feb-20 10:38 
AnswerRe: ESENTUTL in C# Pin
colins52861-Mar-20 22:50
Membercolins52861-Mar-20 22:50 
GeneralRe: ESENTUTL in C# Pin
Richard Deeming1-Mar-20 23:49
mveRichard Deeming1-Mar-20 23:49 
GeneralRe: ESENTUTL in C# Pin
colins52862-Mar-20 6:48
Membercolins52862-Mar-20 6:48 
GeneralRe: ESENTUTL in C# Pin
Richard Deeming2-Mar-20 7:08
mveRichard Deeming2-Mar-20 7:08 

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.