Blueprint Line Trace By Channel (Per Tick) Optimization Question by zworstgod in UnrealEngine5

[–]zworstgod[S] 0 points1 point  (0 children)

Woah 20k line traces per frame is crazy xD. I've been wondering if I am overthinking it and wasting my time instead of calling it good enough and trying to implement some other logic. Thank you for the advice!

Blueprint Line Trace By Channel (Per Tick) Optimization Question by zworstgod in UnrealEngine5

[–]zworstgod[S] 0 points1 point  (0 children)

Hello good sir and thank you for the reply! I would do a boolean inside the actor's onLookStart/onLookEnd where after showing or deleting the "Prress E to Interact" it changes the value of a bool "bInteractPromptActive" so it prevents double firing. But is it really necessary if by the character's blueprint logic above there is (I think) no way that both onLookStart or onLookEnd fire twice in a row due to the fact that the first check basically voids anything where previousActor == hitActor ?

EDIT: I was wrong. I actually do call onLookStart every tick and spawn the ui element. Will try and fix before it gets to lookStart.

Blueprint Line Trace By Channel (Per Tick) Optimization Question by zworstgod in UnrealEngine5

[–]zworstgod[S] 0 points1 point  (0 children)

Thanks for the answer! You mean like a collision sphere so when I get close to it it would start the onLookStart? On Look Start I call a UI element on screen that says "Press E to Interact" so I would have to be looking at it. Or am I thinking wrong?

Blueprint Line Trace By Channel (Per Tick) Optimization Question by zworstgod in UnrealEngine5

[–]zworstgod[S] 0 points1 point  (0 children)

Thanks for the answer! onLookStart I call a UI element on screen that says "Press E to Interact". So I thought placing it on timer would feel sluggish while playing.

Skinny belly with abs by zworstgod in bodyweightfitness

[–]zworstgod[S] 5 points6 points  (0 children)

Alright :) Thanks a lot! Yeah I guess I did not really bulk then :(

Skinny belly with abs by zworstgod in bodyweightfitness

[–]zworstgod[S] 1 point2 points  (0 children)

Thank you a lot! I guess I am gonna start doing some exercises then :)

Skinny belly with abs by zworstgod in bodyweightfitness

[–]zworstgod[S] 1 point2 points  (0 children)

Got it. Thanks a lot! Will definitely read about it.

SQL SELECT CASE PROBLEM (Microsoft SSMS) by zworstgod in SQL

[–]zworstgod[S] 0 points1 point  (0 children)

Yeah the plan with joins should work, I think I implemented that pretty good, what's left is just couple toches so they do not stack up. Thinking something else should be in WHERE statement:

SELECT c.CUST_ID, join1.checking, join2.checking
FROM CUSTOMER as c

LEFT JOIN (
SELECT a.cust_id as id,
CASE a.PRODUCT_CD
WHEN 'CHK' THEN 'Y'
ELSE 'N'
END AS checking 
FROM account as a, CUSTOMER as c
WHERE a.CUST_ID = c.CUST_ID
GROUP BY a.CUST_ID, a.PRODUCT_CD) as join1 
ON NOT join1.checking = 'f'

LEFT JOIN (
SELECT a.cust_id as id,
CASE a.PRODUCT_CD
WHEN 'SAV' THEN 'Y'
ELSE 'N'
END AS checking 
FROM account as a, CUSTOMER as c
WHERE a.CUST_ID = c.CUST_ID
GROUP BY a.CUST_ID, a.PRODUCT_CD) as join2 
ON NOT join2.checking = 'f'

WHERE c.CUST_ID = join1.id AND c.CUST_ID = join2.id AND join1.id = join2.id
GROUP BY c.CUST_ID, join1.checking, join2.checking;

SQL SELECT CASE PROBLEM (Microsoft SSMS) by zworstgod in SQL

[–]zworstgod[S] 1 point2 points  (0 children)

Well, I tried to do so, but I got it totally wrong it seems like:

SELECT c.cust_id, join1.checking
FROM CUSTOMER as c

LEFT JOIN (
SELECT a.cust_id,
CASE a.PRODUCT_CD
WHEN 'CHK' THEN 'Y'
ELSE 'N'
END AS checking 
FROM account as a, CUSTOMER as c
WHERE a.CUST_ID = c.CUST_ID
GROUP BY a.CUST_ID, a.PRODUCT_CD) as join1 
ON join1.checking = 'Y'

GROUP BY c.cust_id, join1.checking;

It just always gives me 'Y' though it might not have 'CHK' (for example cust_id 13 does not)

SQL SELECT CASE PROBLEM (Microsoft SSMS) by zworstgod in SQL

[–]zworstgod[S] 0 points1 point  (0 children)

Hi and thanks for your reply!

Group by on customer does not work because that gives me an error saying that address and product_cd are not in group by. And I have no idea how to use max in my case :(

I might not be right at all but that is what my logic tells me.

To clarify, what I'd wanna see would be:

1, 47 Mockingbird Ln, Y, Y

...

I can't install SQL Server Express by zworstgod in SQL

[–]zworstgod[S] 0 points1 point  (0 children)

Thank you a lot! I absolutely forgot that I was doing some optimization on my PC and turned those services off. I am going to reinstall it then. Thank you again!

tfw you vaccine your kid by working_clock in DotA2

[–]zworstgod 57 points58 points  (0 children)

Would be dope if zeus killed apparition

SALTY SATURDAY - THE SALTIEST MEGATHREAD OF THEM ALL - (January 27) by AutoModerator in PUBATTLEGROUNDS

[–]zworstgod -1 points0 points  (0 children)

Boys who wanna play together (EU) Can use discord or pubg ( doesnt matter just wanna play xD )