• 0 Posts
  • 8 Comments
Joined 1 year ago
cake
Cake day: July 17th, 2023

help-circle


  • You’re being downvoted but I agree. None of this has anything to do with religion. A weird fiction that invokes “[the Christian] God provided the vaccine” is irrelevant and disrespectful to the humans that worked hard to create a vaccine.

    It’s a pretty bad idea in general to bring up a supposedly omniscient, omnipotent, and omnibenevolent “God” in the context of children dying of diseases anyway. What kind of God would allow children to die of cancer? Or any number of other currently incurable diseases?




  • Basically scripts you can run on the fly to pull calculated data. You can (mostly) treat them like tables themselves if you create them on the server.

    So if you have repeat requests, you can save the view with maybe some broader parameters and then just SELECT * FROM [View_Schema].[My_View] WHERE [Year] = 2023 or whatever.

    It can really slow things down if your views start calling other views in since they’re not actually tables. If you’ve got a view that you find you want to be calling in a lot of other views, you can try to extract as much of it as you can that isn’t updated live into a calculated table that’s updated by a stored procedure. Then set the stored procedure to run at a frequency that best captures the changes (usually daily). It can make a huge difference in runtime at the cost of storage space.


  • doctordevice@lemm.eetoMemes@sopuli.xyzToday > Yesterday
    link
    fedilink
    arrow-up
    4
    ·
    edit-2
    10 months ago

    Looks kinda like a particular dream sequence from Vinland Saga. Not exactly what the rest of the show is, but if this image intrigues you I bet you’d like season 1. Season 2 takes a huge tonal shift, I still like it but if you decide to watch just know it won’t be the same as season 1 at all. (This dream is in season 2 but is sort of a reflection on the change itself.)


  • doctordevice@lemm.eetoGaming@lemmy.mlANTI-UNITY STRATEGY
    link
    fedilink
    arrow-up
    0
    ·
    edit-2
    1 year ago

    This strategy can backfire if your game gets popular enough. If both versions are counted separately and they each pass 1mil downloads and the 12 month revenue threshold then you’re paying the higher per-install fee brackets twice.

    To demonstrate, let’s imagine a game like this has 4 million installs in the first year and uses the Enterprise plan for the best pricing structure.

    Scenario A: single version

    • First 1,000,000 @ $0.00: $0
    • 1,000,001-1,100,000 @ $0.125 : $12,500
    • 1,100,001-1,500,000 @ $0.06 : $24,000
    • 1,500,001-2,000,000 @ $0.02 : $10,000
    • 2,000,001-4,000,000 @ $0.01 : $20,000
    • Total cost: $66,500

    Scenario B: two versions priced separately, 2 mil installs each

    Each one is the first four lines above, so the total cost is $46,500*2 = $93,000

    In either scenario, additional installs beyond these 4 million cost $0.01 each (regardless of which game it’s installed on). There’s a fine line of staying below the annual revenue thresholds (or not too far above) where this strategy does save you money.