Do you have a mainframe? (not your desktop PC, but a server/cluster). What are you using it for? Got any pics? Post them here.
I'll start. What you see is my recently procured optiplex farm. They can be obtained very cheap and have pretty good specs. I intend to use them to divide a database by 3, and then have queries run simultaneously on them, as a way of tripling query speed.
how big is the database and what’s the purpose of the database? is the extra power consumption worth the speed?
Jason Parker
>extra power consumption lmao get a load of this poorfag
Mason Ortiz
wait people care about how much power their toys consume? electricity isnt expensive
Jaxon Thomas
Meh, if your dataset can fit in RAM there's no point in adding 3x the failure points, additional network latency, 3x power supplies, 3x the fan noise, etc. It's not about being a poorfag, they could have spent that money on more RAM, a multi-socket board, faster disks, moar cores, etc. Any of which would net far more "query performance" than sharding a database. Thinking 3x computers = "3x the query speed" is just being wasteful and naive. (I'm assuming OPs dataset fits in RAM, because if it didn't he wouldn't be buying *2nd-hand Dell Optiplex* boxen.)
>intend to have them collect dust on the shelves, merely acting as conversation pieces rather than anything practical. ftfy
Ryan Gutierrez
>how big is the database and what’s the purpose of the database? TOP SECRET. But you might have used it actually.
>Is the extra power consumption worth the speed? The 3 of these (at idle) use a combined total of about 55W. So I don't think it will cost that much per month in electricity. Behind, them (which you can't see) is an AMD Athlon II that I run as a media server. Just that media server alone is using 90W at idle D:
>how big is the database Its not big, but its not been easy to optimize it either.
Usually, you don't own the hardware; you are paying for the "service" of using it. In some cases, it even automatically charges you based on the usage. Once you are done with it, IBM takes it back.
Aiden Evans
Freenas box for storage. LTSB 2016 for running everything else. NAS and an everything else box is honestly the best way to go desu.