Lecture 18: What is Partitioning and Sharding in DBMS || DB Optimisation

[@someshanjana2637]

Thanks Lakshya Bhaiya. Love from MP(Ujjain)

[@yogeshwhetwar6345]

A week ago i had my interview and due to which i had stop watching this playlist from this video . In second round of interview the question bcos of which i got rejected is - How you are going to deal when your website have large amount of data and how you are going the manage the requests of so many users.🤣🤣🤣🤣

[@hashirkhan4736]

🤣

[@deepraj2631]

Bhut wait kiya bhai ya, finally aa gyi

[@shivampandey303]

Excellent information, but practical will help more. Waiting for some Basic practical sessions, thank you!

[@aarifhannan4429]

mast but Thora jalde.....upload please CN playlist

[@photon838]

DSA bhi hogya OS bhi DBMS bhi ab khtm 6/7 mahine pehle mujhe kuch ni ata tha bhaiya ab confidence hai kuch bhi pucho bta dunga Thankyou bhaiya for everything 🥺❣️

[@dhiman.shanky]

All the best Mere bhai👍👍

[@R.sh02]

Aur kitne topics hai DBMS me jo is playlist me cover nhi hue , kitna time baad course complete hoga ?

[@ritikabhatt2370]

Ar kitni videos hongi is playlist me bhaiya? Literally loving your work...keep doing

[@lakshaykumar7518]

3 videos more! Stay tuned. One will be out tomorrow.

[@ritikabhatt2370]

@@lakshaykumar7518 Thankyou so much bhaiya ❤️

[@rohitlalwani7288]

Hi love bhaya.. Mera naam Rohit hai m pakistan say hun Aap ki DSA series bhut zabrdast hai main follow kar rha hun currently i am also a software engineer.. all the best love bhaya you are doing amazing job.. May you have been in google soon after amazon and microsoft..

[@anonymous5946]

Are you software developer from Pakistan?

[@rohitlalwani7288]

@@anonymous5946 yes

[@21BEE070_KUMARAMAN]

Here while explaining the horizontal scaling, you are using the example of SQL database, but as we know we cannot use horizontal scaling in SQl.. ?

[@baijukumarsingh8032]

thank a lot sir..

[@056ankitchauhan4]

Great lecture sir

[@daiictupdates]

Computer Networking -Placement series please 🙏🙏

[@adarshtiwari2254]

THANK YOU SO MUCH BHAIYA JOINED 5 DAYS AGO. THESE 5 DAYS HAVE CHANGED MY CORE UNDERSTANDING OF THE CONCEPT AND HAVE GIVEN ME SO MUCH CONFIDENCE THAT OTHER COURSES FAILED TO PROVIDE LOVE THE GREAT WORK . 1 QUESTION APPROX HOW MANY VIDEOS ARE LEFT IN THE DBMS SERIES .THANK YOU FOR EVERYTHING BHIAYA!

[@lakshaykumar7518]

Only 3 are left! 1 coming today...

[@tmiitroorkee1244]

@@lakshaykumar7518 When will the CN series start ? This series is awesome ❤❤

[@sumitsakpal7085]

Maine video pura dekha

[@yashwantptl7]

bohot hi badhiya

[@arunyadav7467]

Be consistent please

[@dikshantprajapat105]

Wait is over 💥💥

[@LiseGarito]

Great video as always! 👍 Need some advice: 🙏 I only have these words 🤔. (behave today finger ski upon boy assault summer exhaust beauty stereo over). I don't know what they are. What should I do with them? 🤷‍♀️

[@nirajjain8099]

Bhaiya jaldi DBMS khtm kerwa do interviews m aadha pdh pdh k ja rhe h 🤣

[@privateguy99]

😂 Bhai Maine Playlist Aaj Start Kiya 😂 Oo Bhi College Syllabus Ke Liye 🤪

[@ekengineer9868]

Hey I'm gonna start watching this playlist, before that can you give a small review of it if u have completed it?

[@panjikarmohit]

Mil gayi job bhaiya ?🤌

[@HARSHSINGH-vs4ot]

​@@ekengineer9868it is one of the best vedio for DBMS in the entire KZbin

[@prakhargupta4320]

Now I am really confused a few videos ago you told us that horizontal scaling is used mostly with NoSQL databases because it's cumbersome to do it with rdbms because of joins and now you are saying that it's going to boost performance. can someone please help me.

[@Pratham__Sharma]

this is a single table getting divided horizontally in chunks , if there were multiple tables with no. of relations based on foreign keys then there will be difficulty while joining them, you r right horizontal scaling is not much used in sql databases. for a single group of data with no foreign relations it is useful.

[@arunyadav7467]

Daily videos chaiye

[@vivekchourasiya1875]

System design k aur course la do bhaiya to perfect preparation ho jaegi

[@GutkaPandu-q2r]

tomorrow will be my infosys sp role interview i hope i will answer all the qn. wish me luck guys !

[@himanshudash-c4c]

thanks

[@ADISHVAR1]

thanku sir

[@NeyongLimbu-l1f]

☑ completed on 6th july 2024

[@nirajjain8099]

Bhaiya air kitne topics bache h..?

[@shamsher556]

Sir Java ka full course kab start hoga

[@vivekteja-4]

Can someone explain how will you handle the issue if db has large data and millions of incoming request?

[@Abhimanyu__Kumar]

I think this is wrong information --> database partitioning is not splitting db on multiple servers: that's db sharding. Partitioning is when we split our db horizontally or vertically on a single server.

[@siddhesh119369]

best lecture !!

[@smilingmahi1835]

Sir, Do confused my preparation for course. How to prepare Java with DSA course for product base company. Please guide me sir

[@deepraj2631]

1dec se interview start h usse phle ho jyegi kya bhaiya😁

[@shamsher556]

Sir Java ka full course With DSA please sir

[@BornHubisLive]

First💯💀💀

[@KratosProton]

great

[@abhimanyukumar513]

Upload CN playlist

[@aviksain1845]

yeh piche macchar kon maar raha tha 😅😅😅😅😅😅😅😅😅😅

[@arunyadav7467]

Consistent please

[@mdmahfuz307]

❤️❤️❤️

[@yogithapallamedi6713]

Can we get the notes of it??

[@tusharvlogs6333]

bhaiya paise toh horizontal scale krne mai bhi lagenge suppose aapka main 10gb ka hai server storage ab apko replica banane ke lie bhi practically 10gb ke server kharidne ya rent out toh krne hae pdenge, toh cost effective to nhi hua horizontal scaling.

[@whybee1892]

bhai storage device ki prices capacity ke saath linearly nahi badhti, for example 1tb ki ssd ka price x tb ki ssd se compare kar. Tera x jab ek thteshold se bada ho jaata hai.. price of x tb storage device becomes greater than x times the price of unit tb storage device

[@sparshbarolia1556]

[@dudamneerajdattu1459]

whats the difference between server and database?

[@MayankLC93]

server is like computer or virtual computer(hardware provided by the services by the cloud) which provide services to client through network. WHEREAS Database is the storage of data in electronic format and could easily accesible to fetch the data.

[@developersdayout]

Which app do you use to write freehand text ?

[@31ankitnain41]

Replica updation delay

[@unknown-wb8jy]

bro, I think, scale-out(horizontal) is more costly then scale-up(vertical). in this video you teach opposite. correct me if I am wrong.

[@shamsher556]

Sir Java ka full course

[@sachinbhandare399]

Itna late kyu bhayya ?

[@vaibhavbisht9649]

🐮🐮🐮🐮

[@shreyaagrawal8916]

Bhai itna slow course kabhi ni dekha. Ek hi chiz ko das bar bolra h. 2X m krne k bad b itna time consuming...only SQL videos were useful...baki to notes dekh k b smjh lete.

[@TarunKumarSaraswat]

Thanks

[@shamsher556]

Sir Java ka full course kab start hoga

[@shamsher556]

Sir Java ka full course kab start hoga