BPM | Prevent Duplicates with Multiple Criteria

[Mark_Wonsil]

@josecgomez

You can always say F* it all and go Code first it’s what I do…

Did you mean F# ?

[josecgomez]

The only F# I ever hit is the notes in the song while I’m showering #Shudder

[THulbert (Tom Hulbert)]

It works!
V2.0
Runs < .5 sec faster than V1.0 (Soooo much speedz)

[josecgomez]

Look at that a whole half second gained… multiply times many times a day and you’ll be saving minutes in no time LMAO

[Banderson (Brandon Anderson)]

@THulbert

Runs < .5 sec faster than V1.0

how long did V1 take?

[josecgomez]

.5 seconds longer

[timshuwy (Tim Shoemaker)]

I just re-did a BPM that is on the OrderRel table… average size order is 25 lines… save time per line for this ONE BPM was .2 seconds… times 25, becomes 5 seconds.
After refactoring, and changing to no TT Join: .02 per release… now it is only 1/2 second for 25 lines. still could be better, but it does quite a bit of work.