PoisonedPrisonPanda

joined 2 years ago

yes indeed. but its about the wall of temperature increase we will soon hit.

everyone will deal with elevated temps if the change is slow.

Im not arguing against recapture. but IMO arguing about technologies wont help us if the system isnt in place.

co2 tax and environment sensitive calculation (lookimg at you capitalism) is not at a place where we can even think of selecting technologies.

[–] PoisonedPrisonPanda@discuss.tchncs.de 5 points 1 month ago (2 children)

why not stop emitting the co2 we are now pushing out and let the global co2 cycle do the job?

some people are arguing about CCS being inefficient and praise DAC.

1.7 °C arent achievable. why they always build dream castles?

[–] PoisonedPrisonPanda@discuss.tchncs.de -1 points 1 month ago (1 children)

Im not arguing about your effictivity.

but that solution would put you on the same level as they are. not caring about individuals.

But honestly. Im always buffeld about the world we live in with so many psychopaths that none has the idea to kill rich mthrfckrs instead of politicians.

yah thats what i meant.

in a way.

[–] PoisonedPrisonPanda@discuss.tchncs.de 5 points 1 month ago (2 children)

luks will also prevent or uphold the encryption if e.g. the power is pulled?

+this means that if someone breaks in, cuts the cables during running decrypted the data is still safe?

[–] PoisonedPrisonPanda@discuss.tchncs.de 2 points 1 month ago (2 children)

you mean that even if the next user formats it you make sure that leftovers/artefacts cannot be read right?

[–] PoisonedPrisonPanda@discuss.tchncs.de 8 points 1 month ago* (last edited 1 month ago) (9 children)

asking out of curiousity: what benefits does encryption have here?

as long the server runs everything is decrypted right? so you are encrypting for the case when someone actively steals your hardware?

edit: stealing as in taking away. but this would mean accessing during runtime is nonetheless possible in a decrypted way?

well.

guide definition:

A structured, often comprehensive document that provides step-by-step instructions to help users complete a task

whats the difference?

[–] PoisonedPrisonPanda@discuss.tchncs.de 7 points 2 months ago (4 children)

good summary.

two thoughts

  • can any expert mention any disadvantages here?
  • what does coolify has to do with this guide?
[–] PoisonedPrisonPanda@discuss.tchncs.de 10 points 2 months ago (1 children)

https://getgreenshot.org/

sitting in the sam boat at work. I like it even more than flameshot at home.

[–] PoisonedPrisonPanda@discuss.tchncs.de 5 points 2 months ago (2 children)

I like that argument. however the only country which is below china in the list of net oil exporter is the US.

which invalidates it.

but sure. US is its own shitshow itself.

17
database greenhorn (discuss.tchncs.de)
submitted 7 months ago* (last edited 7 months ago) by PoisonedPrisonPanda@discuss.tchncs.de to c/programming@programming.dev
 

hi my dears, I have an issue at work where we have to work with millions (150 mln~) of product data points. We are using SQL server because it was inhouse available for development. however using various tables growing beyond 10 mln the server becomes quite slow and waiting/buffer time becomes >7000ms/sec. which is tearing our complete setup of various microservices who read, write and delete from the tables continuously down. All the stackoverflow answers lead to - its complex. read a 2000 page book.

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. the other culprit is that our server runs on a HDD which is with 150mb read and write per second probably on its edge.

the question is. is there a wizard move to bypass any of my restriction or is a change in the setup and algorithm inevitable?

edit: I know that my questions seems broad. but as I am new to database architecture I welcome any input and discussion since the topic itself is a lifetime know-how by itself. thanks for every feedbach.

view more: next ›