For Amusement Purposes Only

The High Corvid of Progressivity

Chance favors the prepared mind.

~ Louis Pasteur

  • 165 Posts
  • 283 Comments
Joined 2 years ago
Cake day: June 20th, 2023
  • arotrios@lemmy.worldtoProgramming@programming.dev•database greenhornEnglish
    1·
    2 months ago

    Lotta smarter people than me have already posted better answers in this thread, but this really stood out to me:

    the thing is. my queries are not that complex. they simply go through the whole table to identify any duplicates which are not further processed then, because the processing takes time (which we thought would be the bottleneck). but the time savings to not process duplicates seems now probably less than that it takes to compare batches with the SQL table

    Why aren’t you de-duping the table before processing? What’s inserting these duplicates and why are they necessary to the table? If they serve no purpose, find out what’s generating them and stop it, or write a pre-load script to clean it up before your core processing queries access that table. I’d start here - it sounds like what’s really happening is that you’ve got a garbage query dumping dupes into your table and bloating your db.

  • arotrios@lemmy.worldtoGames@sh.itjust.works•I had a passionate crush on The Elder Scrolls IV: Oblivion. Could it still thrill me 19 years later?English
    7·
    2 months ago

    I play mages, so the real issue for me is that the magic system in Oblivion is far superior. Being able to craft your own spells is absolutely fantastic. Skyrim cheaped out by removing the complexity and spell crafting, and Shouts didn’t really serve as a decent replacement.

    Combat with the remaster is exceptionally smooth and natural, and I honestly preferred the original Oblivion system than Skyrim’s - which always felt janky to me - like it was trying to use Fallout mechanics to show off, not because it made for a better combat experience.

    The questing and storyline strikes an excellent balance between open world discovery and directed play - Skyrim’s felt disconnected, and I often lost track of exactly what was going on or why. You also get far more background and story - books in Skyrim are usually one or two pages long. Books in Oblivion usually are around 20 - 30 pages.

    The remaster absolutely kicks ass - visually, it’s easily on par with Skyrim graphics, and the audio is fantastic. The performance is far better as well, but it still retains a lot of the old school flavor with the simple interface. I’m really enjoying it thus far - it’s been long enough since i played the original on the 360 that it’s like a new game.

    Plus, it’s got some amazing early 00’s voice talent - Patrick Stewart plays the Emperor, and despite the lines being a bit janky at time due to how they were recorded, the actors did a really good job.

    All in all, it’s AAA title from a time when that meant something, and with the modern engine and graphics, it’s a masterpiece that outshines many of the top titles out today.

  • arotrios@lemmy.worldtoNo Stupid Questions@lemmy.world•If I snapped you back in time 650 years right this very second, how would you use your current knowledge to succeed?English
    41·
    2 months ago

    Nah, just say the plague will ravage the land, war will last for another seventy years, and you’re the only hope of salvation - that pretty much sums up the late 1300s. Then just get your followers off the battle lines, adopt a bunch of cats to keep the rat problem at bay, and practice basic sanitation and isolation - what we learned during COVID.

    Within a couple of years, yours will be the only thriving community. Play your cards right, stay peaceful, prosperous, and show deference to the church and you’ll be pretty much set. Might even wrangle a sainthood if you play your cards right.

    /s to all this of course… most likely I’d just use my extensive knowledge of porn and poetry to try and charm a noblewoman to take care of me.

OSZAR »