You have to create your database without any indexes, then you can add them later for a speed boost
- 0 Posts
- 14 Comments
director@some.instituteto Asklemmy@lemmy.ml•What generic products do you swear are superior to the name brand?3·2 years agoAgreed, Aldi’s stuff rarely worse than equivalent products, and some I prefer more than the name brand. Only things I balk at are fake cheese flavored things and canned goods from their German themed store brand.
director@some.instituteto Asklemmy@lemmy.ml•Android users, What's stopping you from switching to iPhone?11·2 years agoApple really doesn’t offer me anything I want to do above and beyond what Android offers that makes the cost of transition worth it. I’ve been on Android for 13 years, I’m very used to it, know all the tricks. I like the level of control Android gives, I’ve loaded custom roms in the past and I side load apps now. I’ve also never had a (modern) Apple product and never had the need to set up any Apple accounts, so it’d be a pain starting completely fresh.
director@some.instituteto Linux@lemmy.ml•What daily workstation-distro helped or hindered you when learning linux?English2·2 years agoI’ve heard you are supposed to stop by 150
director@some.instituteto Asklemmy@lemmy.ml•What's a single player PC game you can't get enough of?3·2 years agoI still play OpenTTD, happy it got added to Steam.
director@some.instituteto Asklemmy@lemmy.ml•What's a single player PC game you can't get enough of?2·2 years agoIdk, I’m still working on CS1, maybe after I beat it
director@some.instituteto Asklemmy@lemmy.ml•Linux users, what desktop environment do you use?English1·2 years agoXFCE for the longest time, and Cinnamon recently.
director@some.instituteto Asklemmy@lemmy.ml•What operating system do you use on your main computer?English2·2 years agoDesktop is Win 10, laptop is mint.
director@some.instituteto Asklemmy@lemmy.ml•What operating system do you use on your main computer?English2·2 years agoI miss running a Linux machine at work, it was so nice. I imagine that having a modern Linux machine would be even nicer
director@some.instituteto Asklemmy@lemmy.ml•Is impersonation a possible problem in the fediverse?English2·2 years agoConfusing similar domain names are a common thing with email. Micr0soft.com vs Microsoft.com. Same idea could be done with instances.
director@some.instituteto Selfhosted@lemmy.world•[Need advice] My first home serverEnglish6·2 years agoA lot of people start on used small form factor desktops like the ASUS PS52. Other common ones are the Lenovo M series tiny desktops, Dell Optiplex micro desktops or Intel NUCs. These can sometimes be found used for sub $100 a piece from businesses updating their fleets. They can struggle a bit doing stuff that needs some CPU grunt, like live plex transcoding, but are decent otherwise, especially considering the low power draw. You might want to consider spreading that software demand over two or three of them.
director@some.instituteto Selfhosted@lemmy.world•I need help to decided on a name for my Lemmy instanceEnglish1·2 years agoI started one on Linode, a 2gb shared vps. Seems to be running fine so far. Cost per month is $12.
My understanding is that as the amount and speed of memory increases, the usefulness of ECC in detecting and preventing the types of errors that can cause a crash or corrupt a file goes up.
But for home use it’s probably more useful to focus on storage redundancy and backups, or a UPS to keep things running during power blips/outages.
Tons of good options in the used enterprise market. 3-5 years old, usually some paths for basic upgrades, as well as a flood of part availability from all the other similar systems being off boarded that were broken and not resellable. Laptops can be a bit roughed up, but full sized and sff desktops are usually in great condition.