PoisonedPrisonPanda

joined 2 years ago

Wenn ich raten müsste eine Kombi aus:

den wirtschaftsmotor namens rene benko nicht vergessen der gerade stottert.

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

well. indeed the devil's in the detail.

But going with your story. Yes, you are right in general. But the human input is already there.

But you have to have human-made material to train the classifier, and if the classifier doesn’t improve, then the generator never does either.

AI can already understand what stripes are, and can draw the connection that a zebra is a horse without stripes. Therefore the human input is already given. Brute force learning will do the rest. Simply because time is irrelevant and computations occur at a much faster rate.

Therefore in the future I believe that AI will enhance itself. Because of the input it already got, which is sufficient to hone its skills.

While I know for now we are just talking about LLMs as blackboxes which are repetitive in generating output (no creativity). But the 2nd grader also has many skills which are sufficient to enlarge its knowledge. Not requiring everything taught by a human. in this sense.

I simply doubt this:

LLMs will get progressively less useful

Where will it get data about new programming languages or solutions to problems in new software?

On the other hand you are right. AI will not understand abstractions of something beyond its realm. But this does not mean it wont expedite in stuff that it can draw conclusions from.

And even in the case of new programming languages, I think a trained model will pick up the logic of the code - basically making use of its already learned pattern recognition skills. And probably at a faster pace than a human can understand a new programming language.

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

Well. I doubt that very much. Take as an analogy the success of the chess AI which was left training itself - compared to being trained...

Programmers as it turns out are very ‘eh, the code should explain itself to anyone with enough brains to look at it’ type of people

I cannot say how much I hate this.

even worse for old code where proper variable naming and underscores were forbidden. Impossible to get into someone else's head.

[–] PoisonedPrisonPanda@discuss.tchncs.de 4 points 1 week ago (3 children)

Puzzling Stack Exchange

this simply an aggregator?

People also blame ai, but if people are going to ai to ask the common already answered questions then… good!

exactly!

While I am indeed worried about the "wasted" energy (thats a whole other topic), thats pretty much why AI is good for.

[–] PoisonedPrisonPanda@discuss.tchncs.de 4 points 1 week ago (3 children)

I could not comprehend what you were up to telling us.

But the summary is:

The key essence of this post is a deeply disillusioned and angry critique of modern American society, government, and technology. The author expresses a sense of frustration with the perceived emptiness, manipulation, and decay of U.S. institutions—seeing democracy as a facade, tech innovation as overhyped and hollow, and the government as ineffective. They convey a desire for systemic collapse or radical upheaval (accelerationism), suggesting that elites will soon resort to authoritarianism to maintain control. There’s also an undercurrent of socio-political pessimism, nihilism, and rejection of both corporate and state power—coupled with a belief that the current system is unsustainable and nearing a breaking point.

[–] PoisonedPrisonPanda@discuss.tchncs.de 51 points 1 week ago (13 children)

To be honest. (although I am guilty using chatgpt way too often) I have never not found a question + an answer to a similar problem on stackoverflow.

The realm is saturated. 90 % of the common questions are answered. Complex problems which are not yet asked and answered are probably too difficult to formulate on stackoverflow.

It should be kept at what it is. An enormous repository of knowledge.

Well. For now the system is not yet running on the new hardware.

It is now a pondering process of whether migrating everything as it is to the new hardware and then optimize/refactor.

Or refactor before (or at least develop a plan) and then improve during migration....

Be sure to make a new post when you decide what you go with, I’m sure people here would enjoy hearing about your approach.

Nice to hear. Thanks. I will share updates.

[–] PoisonedPrisonPanda@discuss.tchncs.de 0 points 1 week ago (1 children)

BTW. nice username.

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

BTW, your hard disks are going to be your bottleneck unless you’re reaching out over the internet, so your best bet is to move that data onto an NVMe SSD. That’ll blow any other suggestion I have out of the water.

Yes, we are currently in the process of migrating to PostgreSQL and to a new hardware. Nonetheless the approach we are using is a disaster. So we will refactor our approach as well. Appreciate your input.

I don’t know what language you’re working in.

All processing and SQL related transactions are executed via python. But should not have any influence since the SQL server is the bottleneck.

WITH (NOLOCK)

Yes I have considered this already for the next update. Since our setup can accept dirty reads - but I have not tested/quantified any benefits yet.

Don’t do a write and a read at the same time since you’re on HDDs.

While I understand the underlying issue here, I do not know yet how to control this. Since we have multiple microservices set up which are connected to the DB and either fetch (read), write or delete from different tables. But to my understanding since I am currently not using NOLOCK such occurrences should be handled by SQL no? What I mean is that during a process the object is locked - so no other process can interfere on the SQL object?

Thanks for putting this together I will review it tomorrow again (Y).

16
database greenhorn (discuss.tchncs.de)
submitted 3 weeks ago* (last edited 3 weeks 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.

 

dem forum nach zu urteilen trifft man hier einen wunden punkt der arbeitnehmer. :)

 

wie würdet ihr 10k investieren? was meint ihr bzgl. währungsverfall/risiko dollar & euro? wie hat sich euer anlagehorizon mit familie verändert?

2
poltern (discuss.tchncs.de)
submitted 11 months ago* (last edited 11 months ago) by PoisonedPrisonPanda@discuss.tchncs.de to c/austria@feddit.de
 

i geh mal davon aus das a paar vo euch scho im hafen der ehe san bzw. a paar polterabende scho durchlebt hobts^^

hättets ihr lustige ideen fürs poltern?

bitte danke. :*

also net location etc. sondern afoch iwelche aktionen, aktivitäten de ma an junggesellen aufbinden könenn.

3
G'sudert wird! (discuss.tchncs.de)
submitted 1 year ago* (last edited 1 year ago) by PoisonedPrisonPanda@discuss.tchncs.de to c/austria@feddit.de
 

Weil u/Doompickaxe anscheinend noch auf urlaub is übernehm ich mal den obersuderer und wünsche allen ein frohes neues jahr.

Als follow up zur geschundenen Seele dessen Freundin seinen Geburtstag letztes Monat vergessen hat (spoiler: Its me):

Wir haben uns getrennt und ich hab heute damit beginnen dürfen mich um einen neue bleibe zu kümmern.

Also wer bietet mehr?

5
Themenvoting (discuss.tchncs.de)
submitted 1 year ago* (last edited 1 year ago) by PoisonedPrisonPanda@discuss.tchncs.de to c/austria@feddit.de
 

Liebe Community!

Attenzione ATTENZIONE!

Wie letztens angekündigt wollte ich mit themenbasierten diskussionen ein bisserl Bewegung in die Community bringen.

Der Post erzeugte genügend Upvotes um zu den Top posts in letzter Zeit gezählt zu werden und somit dachte ich mir man kanns mal versuchen.


Ich hätte mir vorgestellt man kommentiert einfach mit Themen, Stichworten oder kurzen Beschreibungen, die User stimmen mit upvotes ab bzw. Interagieren/diskutieren.

In der darauffolgenden Woche versuche ich das Thema ein wenig aufzubereiten (ich hoffe mehr tun zu können als den dazugehörigen Wikipedia Artikel zu zitieren) mittels mehrerer verteilter Posts.

Das Ziel ist es mehr posts zu generieren und somit Aktivität hier auf c/austria zu erzwingen.

Ich sehe oftmals 10-20 Upvotes jedoch Kommentare im maximal einstelligen Bereich.

Ich hoffe wir lernen alle ein bisserl was dabei, jeder ist herzlich eingeladen mit abzustimmen oder Theme vorzuschlagen.

Danke fürs lesen!

 

Ich weiß es ist die besinnliche Zeit im Jahr und der Jahresabschluss hängt wie ein Damoklesschwert über unseren Köpfen.

Aber um ein bissl Wind in die Community zu bringen ein Vorschlag:

Passend zum Wöchentlichen Sudermontag könnte man ja auch vl an einem anderen Tag einen arbiträren themen/diskussionspost bringen wo jeder einfach seinen senf dazugibt?

Die klassischen standardartikel Posts erzeugen nur bedingt Resonanz mit den Leuten hier.

Dafür hätt ich halt gmeint in einem post schreibt jeder was ihm so durch den kopf geht oder sonstige Themem die interessant und diskussionswürdig sind und das meist gevotete thema wird dann einfach die darauffolgende Woche thematisiert?

Wsl wäre österreich bezug von vorteil, aber als weltoffene community nehm ich an man muss da net so strikt bleiben.

 

Und wos is mit die franzosen überhaupt los?

 

Ich bin, wie immer, nicht einer meinung mit der ÖVP.

Aber das traurige. Selbst wenn man Sobotka entmachtet und ihn aus der Politik treibt. So wird er weiter in einer blase leben die ihn als ehemaligen Nationalratspräsidenten hochleben lässt und in der er dem türkisen gedankengut bis zum tode fröhnen kann.

Denn so sind wir. Im herzen leistungsträger mit dem herzen buchstäblich am rechten fleck.

Ps: ich hoffe wenigstens auf gelegentlich und obligatorische Krapfen vor seiner Haustür.

 

Da karli is stolz das ma wieder die richtigen kriminellen probleme unseres landes angehen.

 

Frei nachm Schneckerl: "Do san a poar huankinder dabei...

view more: next ›