Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
Search - "slow"
I’m surrounded by idiots.
I’m continually reminded of that fact, but today I found something that really drives that point home.
Gather ‘round, everybody, it’s story time!
While working on a slow query ticket, I perused the code, finding several causes, and decided to run git blame on the files to see what dummy authored the mental diarrhea currently befouling my screen. As it turns out, the entire feature was written by mister legendary Apple golden boy “Finder’s Keeper” dev himself.
To give you the full scope of this mess, let me start at the frontend and work my way backward.
This function allows the user to better see the rows in the API Calls table, for which there is a also search feature — the very thing I’m tasked with fixing.
It’s worth noting that above the search feature are two inputs for a date range, with some helpful links like “last week” and “last month” … and “All”. It’s also worth noting that this table is for displaying search results of all the API requests and their responses for a given merchant… this table is enormous.
This search field for this table queries the backend on every character the user types. There’s no debouncing, no submit event, etc., so it triggers on every keystroke. The actual request runs through a layer of abstraction to parse out and log the user-entered date range, figure out where the request came from, and to map out some column names or add additional ones. It also does some hard to follow (and amazingly not injectable) orm condition building. It’s a mess of functional ugly.
The important columns in the table this query ultimately searches are not indexed, despite it only looking for “create_order” records — the largest of twenty-some types in the table. It also uses partial text matching (again: on. every. single. keystroke.) across two varchar(255)s that only ever hold <16 chars — and of which users only ever care about one at a time. After all of this, it filters the results based on some uncommented regexes, and worst of all: instead of fetching only one page’s worth of results like you’d expect, it fetches all of them at once and then discards what isn’t included by the paginator. So not only is this a guaranteed full table scan with partial text matching for every query (over millions to hundreds of millions of records), it’s that same full table scan for every single keystroke while the user types, and all but 25 records (user-selectable) get discarded — and then requeried when the user looks at the next page of results.
What the bloody fucking hell? I’d swear this idiot is an intern, but his code does (amazingly) actually work.
No wonder this search field nearly crashed one of the servers when someone actually tried using it.
Manager: our file IO is slow, any suggestions to make it faster?
Code: multithread writing to a few hundred small (temp) files then single thread combine to one big file and delete the temp files.
While writing up this quarter's performance review, I re-read last quarter's goals, and found one my boss edited and added a minimum to: "Release more features that customers want and enjoy using, prioritized by product; minimum 4 product feature/bug tickets this quarter."
... they then proceeded to give me, not four+ product tickets, but: three security tickets (two of which are big projects), a frontend ticket that should have been assigned to the designer, and a slow query performance ticket -- on top of my existing security tickets from Q3.
How the fuck was I supposed to meet this requirement if I wasn't given any product tickets? What, finish the monster tickets in a week instead of a month or more each and beg for new product tickets from the product manager who refuses to even talk to me?
Fuck these people, seriously.8
My toxic father. Seriously man. It's my 4th day of learning to drive with an instructor. He sits besides and never knew how to drive. I think I am driving good wrt to being very new in it. He thinks just because I slow myself down on the road and cannot take a turn properly, let me say it again, on the 4th day of driving a manual car, he thinks I can never drive. What a fucking douchebag. What a fucking coward, impatient human says that. I am in rage because now I'm like 27, but in my childhood he was at his worst behaviour. That's why I was always scared of doing complex things, I stick with easy because I will make no mistakes. He has fucking no right in being proud of me. He's so fucking bad, I hate him. But more than hating him I want to find a way not to give a fuck about his fucking small discouraging shameful opinions. Fucker cannot do anything by himself. He's the most messed up fucking person I have ever seen. And oh god I fucking resent this guy.
I should start calling him a fucking retard that way I can devalue him as a person. I could never thought that I will think about a person like this but this retard left me no choice.
The thing is even a person is a retard I will try to understand them so give me a good word that just devalues a person instantly.14
internet connection "speed" in Germany might be the reason why so many people still queuing up on the roads on their way to an office despite being allowed to work from home at least in theory10
Been programming for 3 years now, self-taught but decided couldn't find any job and decided to enroll in college. The teachers are the worst, if I listen to them word for word I get confused about concepts I already know, they're classes are really slow and the teacher focus on a handful of student who slow down the whole class and I'm afraid by the end of the semester they will be rushing.6
And so.. I have noticed.. every time I ignore Windows updates for a little while.. the laptop just starts shitting. It gets so fucking slow that you can’t even move the cursor properly. So you have to force shut down the laptop and turn it ON.. and Windows starts updating!
Not at all irritating 😊3
What do you guys do on low work days? both in terms of
a) Low energy = low work production
b) Low work required of you/slow work day8
Did a presentation to the brass with data so summarized that no informed decision could conceivably come out of it.
They want it even more summarized.
Here is your messy-suit-that-cost-50-grand, version, your overpaid tool:
1) Client be dumb
2) Supplier be slow
3) Money be good
4) We be smart
5) We make money (if you stop meddling and eating my whole morning with a PowerPoint to a meeting you got an hour late to, your fiduciary sack of douchness)
Second week sick I see how my life slowed down and how meaningless everything around is, everyone is rushing about some bullshit, name it new amazing job opportunity, black Friday great deal, super duper product idea or some most important bug on production that we need to fix asap.
All that can’t wait a week when I’m healthy?
Seriously, people lost their minds in today’s world to some bullshit.
I’m to old and to depressed to care about such idiotic things. Living my life as I want and on my own peace, don’t care everyone is running, I’m slowly walking and I like it.
It’s better to walk straight than run around like an idiot.1
Playing Galagon/Galaga on my dad's slow-ass toshiba company laptop. I still sometimes boot it just to play again
Client has decided to buy another server because the old one is too slow
Manager: how long will it take to move our apps to the new server
Me: maybe 3-4 hours
15 hours later
Manager: why isn't it finished yet?
Me: because I have to install a lot of missing things on the new server, and I have to google a lot to find them
Me (thinking): because your 15-years old apps suck big time4
I'm building a desktop Java application, the build is running from 20 minutes and it keeps going... and people still mocks C++ for being slow in building5
Working on an Angular project for the change of things. God, please kill me already.
Its fucking slow - hot reload? I am gonna make myself a coffee in the meanwhile
Its fucking stupid - Why make it easy when you can make black boxed. Make the magic happen!
And please dont get me started on Ressources, documentation, error messages and all the other stuff thats annoying here. Never going back to Angular, if it wasnt paid that well…3
Looking at vacancies and the JS build tools asked (Babel, Gulp) and then visiting their websites I notice that I don't understand what they are going on about.
What the actual corpo fuck?
I've been out of the corporate loop for a few years, seems it's all about build tools these days. I need to get out of this industry pronto.3
why is my charger so loose
my phone is dead because my charger is charging slow
its really loose in the port and it falls out sometimes
a lot of the time it doesnt even work when its laying flat
my phone died while it was charging, which is a first
So it me again and loviing my life at this tech startup..... i feel like I'm actually achieving something thogh at a slow pace
I know i can give out more to this startup.....but there is this 1 manager in our technical department......FUCK the old man thinks he knows everything and so damn arrogant.... at one time he made a fucking simple error which was fucking obvius but the man you cant tell him anything
if anything goes wrong or if anything isnt working the FUCKING old man is quick to throw the blame on people which i feel isnt supposed to be a mind set of some1 in the technical department..... I get it yes sometimes it will be the person making errors but even when you do it right and its not coming out as its supposed to be the damn OLD FUCKING MAN says you are doing it wrong.....then he steps in and bang....it fels and he'll be like "WHAT? HOW WHATS GOING ON...."
and me silently will be like MAKE IT WORK FUCKING OLD GENIUS
I cant even bring in new ideas and systems into the company......hell be like WE ALREADY HAVE SYSTEMS IN PLACE.... guess what..... no fucking system is being used
took me four hours plus to get a nodejs app to successfully run on cpanel.
at this point I just want to sleep and sleep forever.
why will anyone ever want to deal with this?
the ssh access? complete crap but it was better than having to deal with the janky ui, it was also slow as fuck1
got kicked out of a contract today because the owner felt I wasn't moving at the pace he wanted, there were no milestones but even i knew I was slow.
this happened when I started talking to a therapist because I was beginning to have suicidal thoughts and anxiety issues.
I had to run work errands for my everly screaming mom and manipulative dad.
these same people who I begged with no success for money to buy a used core 2 duo laptop for programming projects.
I was in the bus in the afternoon sun trying to get three books from a publisher that ended up being a waste of time because she didn't follow instructions and insisted on screaming over the phone at the attendant. the client requested a meeting and I couldn't respond positively,
I get home and my dad wants me to travel down to our village home to meet with some kid he kept giving money because they wanted to have a meeting. I'm so annoyed because I told him I wanted this week off to face this already dead contract and he just ignores all of that and fixes a meeting.
I pay for electricity and gas for these people and they still treat me like shit. fuck this !1
A philosophical question about maintenance/updating.
There is no need to repeat the reasons we need to update our dependencies and our code. We know them/ especially regarding the security issues.
The real question is , "is that indicates a failure of automation"?
When i started thinking about code, and when also was a kid and saw all these sci fi universes with robots etc, the obvious thing was that you build an automation to do the job without having to work with it anymore. There is no meaning on automate something that need constant work above it.
When you have a car, you usually do not upgrade it all the time, you do some things of maintance (oil, tires) but it keeps your work on it in a logical amount.
A better example is the abacus, a calculating device which you know it works as it works.
A promise of functional programming is that because you are based on algebraic principles you do not have to worry so much about your code, you know it will doing the logical thing it supposed to do.
Unix philosophy made software that has been "updated" so little compared to all these modern apps.
Coding, because of its changeable nature is the first victim of the humans nature unsatisfying.
Modern software industry has so much of techniques and principles (solid, liquid, patterns, testing that that the air is air) and still needs so many developers to work on a project.
I know that you will blame the market needs (you cannot understand the need from the start, you have to do it agile) but i think that this is also a part of a problem .
Old devices evolved at much more slow pace. Radio was radio, and still a radio do its basic functionality the same war (the upgrades were only some memory functionalities like save your beloved frequencies and screen messages).
Although all answers are valid, i still feel, that we have failed. We have failed so much. The dream of being a programmer is to build something, bring you money or satisfaction, and you are bored so you build something completely new.13