Well I just did a SELECT CUNT from a table...
Not sure what to think about that :)

You were a naughty boy 😏

Even worse, during this session I thought I wouldn't be able to optimise the process much, but so far I brought it down from 22 seconds to 15 seconds... And I'm not done with making small optimisations along the way so I guess that's the mindset I need to be in to get good performance :)

Don't be surprise if suddently all your colleagues come to you 😂😂

What's the name of the column that you misspelled with cunt
?

@greenhouse the function COUNT

I do this all the time - must be something freudian

@jAsE ~14500 😎

@Bikonja lol nice : )

Nice. I create pubic functions sometimes.

@bighead oh yeah, that happened to me as well. I believe there's more, but I can't recall which ones. There's definitely non-dirty ones, but I think there's even more dirty ones.
It's all good if noone is watching you type and if you catch the mistake before committing changes :)

@Bikonja What kind of optimizations? 0o

@SpectralKH taking a month's worth of data, analysing it and creating a weeks worth of new data based on it. It's a prediction algorithm. Takes historical data and tries to predict what the data will be in the future based on that.

Was it the 'customers' or 'clients' table?

@hawkes neither

We had something called analyzer script in my previous company. I gave it a popular alias. Had to run it once infront of my manager.

any time I have to alias the Countries table with 3 letters in a JOIN

@Bikonja Oooooooh that sounds cool and complicated

@SpectralKH it sounds better than it is :) in reality it's pretty much just support and explaining why things are the way they are, trying to deal with clients not trusting the system, then changing it to match their requirements, then changing it back because they realise that's not good, etc... :)
If I had the power to just improve it and get feedback without being forced to implement changes that clients want but what I think is best that would be amazing, yeah

Oops, I did it again :)

Did it return you? :O

It returned itself :O