• 0 Posts
  • 19 Comments
Joined 2 years ago
cake
Cake day: August 7th, 2023

help-circle
  • It’s the round trips that kill you.

    Oracle drivers for .NET are fun. Have a user client application which uses quite a lot of data, but a few thousand rows are fetched some queries. It’s way too slow for any larger query, turns out for the batch query kind of work we do, the default FetchSize for Oracle is just a performance killer. Just throw it to 128 MB and it doesn’t really hurt at all.

    Worst thing i’ve seen though, apart from the 150 line long dynamic sql stored in our database, was probably a page in our program that loaded about 150 rows from the database. Normally we do create a new connection for each query, but it’s fine since Oracle has a connection pool. Whatever millisecond is trumped by the round trip. But imagine a UI so badly written, it did 4 separate database queries for EACH row it loaded into the UI list. Useless things like fetching a new ID for this row in case it is changed, reading some data for the row i think, and more. Thing took a solid minute to load. There was so many bad patterns in that page that even during the PR for improving the speed it was just dealing with a mess because you couldn’t just rewrite the entire thing, so they had to make it work within the constraints. Horrible thing to work with.





  • My experience with W11 on the work laptop.

    Taskbar sucks, maybe because I’m colorblind but I can te what my selected program is and programs with notifications (Teams) look like the focused program. Apparently notification boxes there are pink now. Can’t find any accessibility setting but fuck the colorblind I guess. It feels wrong to click the highlighted icon I for years have learned will mean that I minimize it…

    And why all the dots? And why is the notification dot the largest, so I can even tell which window is actually focused?

    Outlook doesn’t open with focus, especially the window that is supposed to pop up and warn me of upcoming meetings. Really annoying.

    Teams notifications just don’t show if you are in a meeting and that is focused, they used to do that on W10.

    Might be a Firefox bug, but there’s a lot of new visual bugs. Github diff view is randomly strongly colored, and randomly changes to the old weaker background colors when scrolling/resizing the windows. And a surprising amount of scrollbars in grids that weren’t there before.

    I just wish W11 at least worked with the regular features of W10.


  • I principally agree with you, it’s why I use reddit/lemmy and not 4chan.

    But there is a difference, albeit hard to convey correctly through text. But I think some of the extreme responses mentioned are the ones in the banter type. It’s a kind of response when someone jokingly says “Star Wars and Star Trek is pretty much the same” and you go “I’ll skin you alive” due to the unjust comparison. It sure as hell don’t work with strangers, but it can within an community since everyone knows neither party is serious about it. Which is what the original post kind of says that it can work in the right community.




  • Code normally works fine after you write it and then hopefully at least test by hand. The new guy 5 years later, which do not fully grasp the extent of his actions, and the guy reviewing the code also not being too familiar with it, will not make sure everything does as intended.

    Tests are correctness guarantees, and requires the code and/or the test to change to pass. They also explain how something should behave to people that don’t know. I work in a area where there are so many businesses rules that there is no one person that knows all of it, and capturing the rules as tests is a great way to make sure that rules remains true after someone else comes to change the code.


  • In modern games, I think it’s fairly common to have a common 3d skeletons share names. So you can make animations like the one above apply to any character even if they have differences. It doesn’t mean that dog extends human, but it may mean that a dog model shares a lot of common “bones”, that are used for movement, with a human model.

    So when a human animation is applied to the dog, you can see it warp to start position of the animation, move, and then then stop at the end position as a standing human, before warping back to idle animation (when it turns back into the dog shape)

    Related, weapons in Destiny also share the same components across weapon types, and bugs have caused one weapon type to be used for another weapon, making funny things happen. Like how a hand canon (pistol) stretches like a bow because it’s model got used in place of the bow model at the start of this clip:

    https://www.youtube.com/watch?v=0YZa9vv5U0M




  • None of those issues for my main IDE, though Rider on some occasions do get stuck marking some spelling errors after they are fixed.

    It has stuttered a few times, but pretty rare. But it does have a bug where it think it is building a project, but isn’t. And requires a restart to fix… Easy to trigger if you try building a project while it’s loading the project…

    Visual Stuido with Resharper is the one where things would randomly stop working though. Especially hotkeys would sometimes stop working until I restarted it. Slow and stutter too.


  • Not sure if this advice really applies, given i haven’t used Git for any reports myself and I don’t know how you are doing the text based project. I did pretty much all my uni reports in a online latex document site which allowed shared editing, so there was some history but all edits were live to the main doc.

    But with the power of latex at least, you can have the main file do import and usages, and maybe some setup. And then combine other files representing anything you want. Such as one for front page, one per chapter or one for appendixes.

    Then just can do changes/new sections in feature style branches, and it’s up to you if you want things to go to the main branch, or have a dev like branch where further refinement can happen if your work is structured and not all over the place like my report writing was.