Mohammed Afzal

A Tech Enthusiast! Tweets about Cars, Programming and latest Tech ⚡

[GitHub Projects Community @GithubProjects]

YouTube player, without ads, ideal for e-learning and also saves your progress locally, no account required.

[Mohammed Afzal @afzaltec]

@JioCare This is totally unacceptable @JioCare. How could you not find the complaint when it is visible in my jio app? #jioscam #ScamAlert

@C4ETech @Geekytamizha_ @geekyranjit what's your opinion on this?

[Mohammed Afzal @afzaltec]

Had a very bad experience with @JioCare. Our jio fiber was down for 8 days from 12th Sept to 20th Sept and when I dialed with customer care, only Bots answered, just repeating "ticket is raised". No actual customer support is provided. (1/2)

[Mohammed Afzal @afzaltec]

https://t.co/tkvt1mA4ZG

[Mohammed Afzal @afzaltec]

@Samhere2020 @DealBeeOfficial Same here

[Tarun Vats @tarunvats33]

Great News !!

Galaxy S23 Series: The official One UI 8.0 beta Samsung Community page has been created, but so far only in Germany.

It has not yet been found for the US, UK, Korea, India, or Poland

[Khaled 🍉 @TechKhaled_]

Best Face is available on Beta 2 of S23 series

[Prasanna S @myprasanna]

My name is Prasanna, who previously founded Rippling (worth $10B); I'm going through a divorce. I'm now on the run from the Chennai police hiding outside of Tamil Nadu. This is my story.

[TX @DotSlashTX]

A SCAM pulled off by one of the Top 3 contestants in this hackathon, won whopping 75 Lakhs of funding just by rebranding @brave Browser!
This is bigger than one can think!
Tagging @AshwiniVaishnaw and @GoI_MeitY @cdacindia.

[Shishir @ShishirShelke1]

Samsung's weather app is beautiful

[Marko Denic @denicmarko]

CSS tips you won't see in most tutorials:

[Nikki Siapno @NikkiSiapno]

Things every developer should know — SQL execution order.

A SQL query executes its statements in the following order:

1) FROM / JOIN
2) WHERE
3) GROUP BY
4) HAVING
5) SELECT
6) DISTINCT
7) ORDER BY
8) LIMIT / OFFSET

The techniques you implement at each step help speed up the following steps. This is why it's important to know their execution order. To maximize efficiency, focus on optimizing the steps earlier in the query.

With that in mind, let's take a look at some optimization tips:

1) Maximize the WHERE clause

This clause is executed early, so it's a good opportunity to reduce the size of your data set before the rest of the query is processed.

2) Filter your rows before a JOIN

Although the FROM/JOIN occurs first, you can still limit the rows. To limit the number of rows you are joining, use a subquery in the FROM statement instead of a table.

3) Use WHERE over HAVING

The HAVING clause is executed after WHERE & GROUP BY. This means you're better off moving any appropriate conditions to the WHERE clause when you can.

4) Don't confuse LIMIT, OFFSET, and DISTINCT for optimization techniques

It's easy to assume that these would boost performance by minimizing the data set, but this isn’t the case. Because they occur at the end of the query, they make little to no impact on its performance.

If you want to create efficient queries, it's a good idea to understand how things work under the hood otherwise your efforts may be wasted. While these tips work best in most cases, you should consider your unique use case when choosing the best course of action.

[Mohammed Afzal @afzaltec]

@striver_79 Congratulations!

[Stebaa @S_Tebaa]

One ui 7 & Good lock 🔥🔥🔥
#OneUI7

[Mohammed Afzal @afzaltec]

@DealBeeOfficial Wow that's amazing! Just referred my friend

[Out of Galaxy @OutofGalaxyy]

Let's just agree that Samsung has the most beautiful weather app 😍

[Mohammed Afzal @afzaltec]

@geekedout__ Nice review!

[Vijay Patel @vijaygajera]

DIGITAL ARREST SCAM🚨

FIRST TIME LIVE RECORDING.

1. Please read, watch, and share this thread as much as possible so we can save more people from this fraud.

[Yasmine Khosrowshahi @yasminekho]

I distilled my 4 years of marketing lessons into minimalistic visuals.

1. Sell Benefits. Not features.