How is there an entire page without a single line describing how it works?
Readit Newsgulikoza commented on WinBoat: Run Windows apps on Linux with seamless integration github.com/TibixDev/winbo... · Posted by u/nogajun
gulikoza commented on Windows 7 boots slower if you set a solid background color support.microsoft.com/en-... · Posted by u/ShaneCurran
This was a problem even for systems with more RAM, because that background bitmap was always a tempting target for the memory manager looking to page out long idle memory. It was exacerbated by the aggressive disk cache, which could cause even programs that didn't allocate much memory directly to swap out the background by doing enough regular buffered I/O.
Add that before UDMA modes any disk I/O burned CPU cycles as well. A single core CPU spent most of the time reading from a slow disk. Good times!
gulikoza commented on Windows 7 boots slower if you set a solid background color support.microsoft.com/en-... · Posted by u/ShaneCurran
Hands up all the people that used computers before desktop pictures were a thing and still set the desktop to a solid colour because “it will draw faster and use less memory.”
Windows before some version (maybe before XP?) only supported BMP wallpapers. BMP is uncompressed, a 1024x768 24-bit BMP is 2.25MB. That could be 7% of the 32MB system RAM and if the image got paged out - you were looking at it being redrawn line by line...yeah, I'm not doing that :)
gulikoza commented on You probably don't need query builders mattrighetti.com/2025/01/... · Posted by u/mattrighetti
At least for MSSQL: Never do this (before learning about query caches). Or at least, if you do, add (option recompile) to the query.
For each combination of parameters to search for you may want to use a different index.
But... the query plans are cached by query string lookup!
So it is imperative that your search string looks different for each query plan/index being used.
The code suggested here will pick a more or less random index (the one optimized for the parameters of the first execution) and stick with it for remaining executions, leading to bad queries for combinations of non-null that doesn't match the first query.
You could just add a comment inside the string that was different depending on what parameters are null, but that is no less complex than just generating the query.
PS: Of course there are situations where it fits, like if your strategy is to always use the same index to do the main scan and then filter away results from it based on postprocessing filters. Just make sure to understand this issue.
This ^
I debugged an app a couple of years ago that from time to time brought entire MSSQL down. The server had to be physically restarted. Nobody could figure out for years what was going on, all the queries had been analyzed and checked for missing indexes, everything was profiled... Except when an app generated a query like this which did not go fine through the cached plan.
gulikoza commented on Voice acting in Space Quest V github.com/cdb-boop/Space... · Posted by u/elvis70
I forgot to nab the audio, but I have patches. Care to swap?
See the other comment below.
Maybe you also have a hash of the patches? :)
gulikoza commented on Voice acting in Space Quest V github.com/cdb-boop/Space... · Posted by u/elvis70
Could you release a torrent for it? Maybe someone else has the patches
I'm not sure if I can.
But if anyone else has the file, the hash is: 82c6658d53fa611273a4742ac824cc98196fd35e
Should be pretty magnetic :)
gulikoza commented on Voice acting in Space Quest V github.com/cdb-boop/Space... · Posted by u/elvis70
gulikoza commented on Rocky Linux, Reflections on Three Years of Growth rockylinux.org/news/happy... · Posted by u/nuker
> The GPL only requires that you provide sources to those to whom you distribute binaries, not to the general public.
Interesting. I looked at Wikipedia GPL page and saw this: "The GNU General Public License (GNU GPL or simply GPL) is a series of widely used free software licenses or copyleft that guarantee end users the four freedoms to run, study, share, and modify the software.[7] "
So any user of GPL covered software can share it with anyone. Right? Can any RHEL user share sources to Rocky? And to public?
That's where the disagreement is. Yes, it can be shared but RedHat under their license is not bound to provide you with any further updates.
However, this makes it as if you are being punished for exercising the rights that have been given to you by the original software license.
gulikoza commented on Death by AI – a free Jackbox style party game. AI judges your plans to survive deathbyai.gg... · Posted by u/overactor
I was thrown into a bottomless pit, but I reasoned that it must have a wall, right?
So I said that I maneuvered like a skydiver to get to the wall, and then climbed out.
But the AI didn't seem to think that bottomless pits have walls.
I died. How? It didn't say.
I survived by saying since it's bottomless I never reach the ground.
"It's the ground that kills you, not the fall" :)
I've got a nice mailu config and wanting to expand with Nextcloud (or alternative) and likely xmpp services... I mostly use a pretty light host VM and docker compose configuration to make up/down/backup/restore pretty smooth... I'm not currently running across multiple servers, but do want to be able to have a slightly more consistent config... I've got a combination of Caddy and Traefic on the different servers for TLS and all my apps are /apps/appName/(data|docker-compose.yml) on the server(s). Which keeps my maintenance chores relatively simple from a couple remote ssh commands and rsync.
Mostly been a bit lazy in terms of getting this all done.
I switched to Nextcloud Talk after Skype shutdown and migrated all my family there. They love it. We have a private cloud, we can share photos and other files, great mobile support... The only issue at the moment is relatively long delay before receiving a message (up to 30secs?) since I've been too lazy to setup redis.