Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon) database.husseinnasser.com

What would be nice is to have some numbers to see the real impact on performance and to know which of this factors are more crucial

Hussein I truly look up to you ❤

@aaqibhamdule73

Жыл бұрын

u even look like him 🤣

35 seconds in. Noticed the background is less noisy - love that it's just three books. And the lighting is softer. This is nice. I thought the sword was gone till I googled the word Musashi and realized the spirit of the Samurai is still very much here. This is nice too. Back to SELECT * . Hopefully this is the video where it finally sinks in for me what your *fetish* for "SELECT *" is. I'm a big fan, Hussein, I can say you played a big part in my having the career and approach to learning that I have now. But as anybody who's watched numerous videos you've made on databases would notice, you have a thing for SELECT * :)

You Sir, are an inspiration for me ❤

Bigger problem than it being slow is that it could cause issues with your code when you rollback failed deployments after db migrations because db migrations could add new columns that your older version of the code does not recognise and fail to scan.

The man’s a hero

I enjoy the details you get into.

Thanks you for providing such high quality vids 🙏

Thanks for another great video!

thank you for sharing these valuable info

Hussein you are such an inspiration ❤️

Kids these day will not call you cringe. They will call you 'an amazing person who teaches us so much and gets us interested in learning the fundamentals'.

Thank you very much sir. This is a very detailed explanation.

Great video sir, you teach the good stuff

Hi Hussein, what you think about ORM? is it worth to used? the pros and cons? any video about it? I would love to watch it thanks :))

Would love to have the video reg File block and byte. How Read operation is done and its underlying logic

great and informative watch..

Hey Hussein, I have one question- How is select * different from select col1, col2, col3,col4 where id =1? - say I have 100 columns in my DB or some very high number of columns At the end it has to still figure out the page where col1,col2,col3,col4 are , right ? The only part that would be less is- deserialisation cost, n/w cost . But the main part of searching the remaining the columns from heap still lies there even if we are selecting few columns as opposed to *. Is my understanding correct ? can you shed some light ?

But if you actually need everything, SELECT * is not slower than selecting every column explicitly, right? So SELECT * isn't slow. Selecting in general is slow.

@davincis1

Жыл бұрын

You never use * . Unless you want to get hacked and show all nice customer data that should be hidden :) . As well, in many cases you not need all columns as it increases the time you get the data

@Mohamedrasvi

Жыл бұрын

This is exactly my thinking. Select * is not slower than selecting explicitly by specifying all columns. The video is talking about selection unnecessary columns.

I'd love to if you can review Citus postgres distribution

Best CHANNEL

Great video 😀

Hi Hussein, what would be the impact of using an guid as primary key column vs using an autoincrememt as a primary key column?

@ayaanqui

Жыл бұрын

I'd like to know this too

@drpstar

Жыл бұрын

Read his blog on postgresql vs mysql. There he has mentioned some details on this topic.

I listen to your shows when going for a walk and damn so much info i gain during that 40 mins.

"A page is.. and a block.. is the most overloaded term in SE." 😅

Question: if I do “select *” and in the where clause I put a indexed column - what’s even the benefit of using the index if eventually the db will have to do a table scan?

@pixaim69

9 ай бұрын

The dB will do a seek and not a scan.

Hi Hussein, Even the queries selecting few columns like select a,b,c from t1 where grade>90 still needs to fetch the pages from Disk Randomly how is it greatly different from select *

@drpstar

Жыл бұрын

But there is still that unnecessary IO cost of large columns ( text, blob), serialization and de serialization cost, CPU cost for compression and not to mention networking one.

@saikatduttaece50

11 ай бұрын

@@drpstar What is we actually need that large column too.

Great video ✨

The guilt trip whenever I am gonna do a select * from now on 😂

at this point hussein is a DBA or even better cause he can build scalable backends too, change my mind 😆

"Next time you do a 'select * ...' think about the suffering you're causing to all this equipments" 😂😅 26:06

The videos are kind of good, but man I feel so bad for not being able to sit through this dramatic explanation of things. It’s either my ADHD or just that my grandfather just gets to the point much faster than this. It’s like if buffering had a modern look

Deserialisation is not a problem.

title is confusing. Star operator is not the suspect here.. but the deep dive is interesting nevertheless, although, a bit chatty imho.

Its slowww... Looking at you Entity Framework, or pretty much any ORM 😅

@NathanHedglin

Жыл бұрын

Haha Entity Frameworks Core is MUCH faster.

@wolfVFXmc

Жыл бұрын

You can select what data you wanna return from the database in EF core

test