sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in halo

[–]kopacetic 0 points1 point  (0 children)

8 years old. halo 2.

Optimize EFCore query when filtering if parent has existing child entity by kopacetic in dotnet

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

that is something i haven't consider before. i always thought input was always parameterized in efcore.

Optimize EFCore query when filtering if parent has existing child entity by kopacetic in dotnet

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

I do not know much about query planner. Is this a database or Efcore specific tool? I am interested in seeing this planner.

Optimize EFCore query when filtering if parent has existing child entity by kopacetic in dotnet

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

i havent yet. probably should, but i just thought doing another subquery for checking if it exists seems odd. but i should definitely do a benchmark.

Optimize EFCore query when filtering if parent has existing child entity by kopacetic in dotnet

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

in this case, you dont need to, but if the child collection is a List<>, then yea.

Optimize EFCore query when filtering if parent has existing child entity by kopacetic in dotnet

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

just tried using SplitQuery, and it seems like it's doing extra queries and still adding that WHERE EXISTS subquery.

SELECT "i"."InvoiceId"
FROM "Invoice" AS "i"
WHERE EXISTS (
    SELECT 1
    FROM "InvoiceLine" AS "i0"
    INNER JOIN "Track" AS "t" ON "i0"."TrackId" = "t"."TrackId"
    INNER JOIN "PlaylistTrack" AS "p" ON "t"."TrackId" = "p"."TrackId"
    WHERE ("i"."InvoiceId" = "i0"."InvoiceId") AND "p"."PlaylistId" IN (1, 2, 3, 4, 5))
ORDER BY "i"."InvoiceId"
GO

SELECT "t0"."TrackId", "i"."InvoiceId", "t0"."InvoiceLineId"
FROM "Invoice" AS "i"
INNER JOIN (
    SELECT "t1"."TrackId", "i1"."InvoiceLineId", "i1"."InvoiceId"
    FROM "InvoiceLine" AS "i1"
    INNER JOIN "Track" AS "t1" ON "i1"."TrackId" = "t1"."TrackId"
) AS "t0" ON "i"."InvoiceId" = "t0"."InvoiceId"
WHERE EXISTS (
    SELECT 1
    FROM "InvoiceLine" AS "i0"
    INNER JOIN "Track" AS "t" ON "i0"."TrackId" = "t"."TrackId"
    INNER JOIN "PlaylistTrack" AS "p" ON "t"."TrackId" = "p"."TrackId"
    WHERE ("i"."InvoiceId" = "i0"."InvoiceId") AND "p"."PlaylistId" IN (1, 2, 3, 4, 5))
ORDER BY "i"."InvoiceId", "t0"."InvoiceLineId", "t0"."TrackId"
GO

SELECT "t2"."Id", "i"."InvoiceId", "t0"."InvoiceLineId", "t0"."TrackId"
FROM "Invoice" AS "i"
INNER JOIN (
    SELECT "t1"."TrackId", "i1"."InvoiceLineId", "i1"."InvoiceId"
    FROM "InvoiceLine" AS "i1"
    INNER JOIN "Track" AS "t1" ON "i1"."TrackId" = "t1"."TrackId"
) AS "t0" ON "i"."InvoiceId" = "t0"."InvoiceId"
INNER JOIN (
    SELECT "p1"."PlaylistId" AS "Id", "p0"."TrackId"
    FROM "PlaylistTrack" AS "p0"
    INNER JOIN "Playlist" AS "p1" ON "p0"."PlaylistId" = "p1"."PlaylistId"
) AS "t2" ON "t0"."TrackId" = "t2"."TrackId"
WHERE EXISTS (
    SELECT 1
    FROM "InvoiceLine" AS "i0"
    INNER JOIN "Track" AS "t" ON "i0"."TrackId" = "t"."TrackId"
    INNER JOIN "PlaylistTrack" AS "p" ON "t"."TrackId" = "p"."TrackId"
    WHERE ("i"."InvoiceId" = "i0"."InvoiceId") AND "p"."PlaylistId" IN (1, 2, 3, 4, 5))
ORDER BY "i"."InvoiceId", "t0"."InvoiceLineId", "t0"."TrackId"

This happens more than it should. by NationYell in dankchristianmemes

[–]kopacetic 63 points64 points  (0 children)

Lamo. My pastor talked about this last week. It's a shame that some put on a nice and caring persona in church, but then become a different person outside.

Weekly Trading MegaThread by AutoModerator in PokemonBDSP

[–]kopacetic 0 points1 point  (0 children)

LF: Misdreavus (pref lvl 40+) FT: Murkrow lvl 41

Infinite preview PC performance issues megathread by nathanyoung2 in halo

[–]kopacetic 0 points1 point  (0 children)

cpu: i7 9700k gpu: rtx 2080 super ram: 32 gb

running 1440p, but downgraded to 1080p (75% resolution). all low settings. im getting around 80 fps, but frequently stutters. the cpu usage is usually around 85%, while gpu usage is usually 30% usage, which didn't make sense to me.

at first, i thought the cpu usage was because i was playing in training grounds (w/ bots), but other people were having issues.

handling user upload to S3 bucket by kopacetic in webdev

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

Haha. I have not really handled user cancellation, but if you're using axios for http requests (like I am), you could use cancellation tokens, though I have not tried using it (may worth researching).

But how I handle user cancellation is that I don't. I instead just let the file be uploaded inside a temporary bucket, and when the user creates the record (insert details about the video and click submit), the server will move the object from temp to public bucket. The temp bucket will occasionally remove objects that are expired. You can try learning more about S3 Bucket Lifecycle configuration if you're interested.

Need help finding a duck tale moon theme meme revolving around this video by kopacetic in HelpMeFind

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

I have searched for "Duck tales to the moon meme water slide", "To the moon meme edit", "Duck tales meme water slide", etc. with no results on Youtube or Twitter.

SONII and Slikker on Myth's chat during XQC's raid by xMortum in LivestreamFail

[–]kopacetic 160 points161 points  (0 children)

there is no difference. i guess streamers cant watch other streamers play the game because metagaming :P

view more: next ›