Spring Data JPA | Query Hints | Optimize Database Performance | Hands-On Guide

#JavaTechie #Microservice #SpringBoot #JPA
👉 In this tutorial, we dive deep into Query Hints in Spring Data JPA. Learn how to leverage them to optimize query performance with practical, real-world examples.
What You’ll Learn:
👉 What are Query Hints?
👉 The different types of Query Hints.
👉 A hands-on example with step-by-step implementation.
👉 Performance comparison: before and after using Query Hints.
🧨 Hurry-up & Register today itself!🧨
Devops for Developers course (Live class ) 🔥🔥:
javatechie.ong...
COUPON CODE : NEW24
Spring boot microservice Premium course lunched with 70% off 🚀 🚀
COURSE LINK : Spring boot microservice course link :
javatechie.ong...
PROMO CODE : SPRING50
GitHub:
github.com/Jav...
Blogs:
/ spring-data-jpa-query-...
Facebook:
/ javatechie
Join this channel to get access to perks:
www.youtube.co...
🔔 Guys, if you like this video, please do subscribe now and press the bell icon to not miss any update from Java Techie.
Disclaimer/Policy:
📄 Note: All uploaded content in this channel is mine and it's not copied from any community, you are free to use source code from the above-mentioned GitHub account.

[@manishkeshari5096]

East or West, Java Techie is the best ❤

[@MohamedKaanoun]

Bro deserves 100M subscribers

[@Javatechie]

I don't know the true buddy whether i could reach even 1M or not however This word is enough for me to boost 🥰

[@reshmasoni7671]

I think gold button from KZbin ❤❤❤

[@richardvincent3979]

Not 100M please, 1Billion. Your information are always relevant. Thank you for consistently delivering value. You are the best

[@Javatechie]

Thank you Richa for your good wishes 🥰. Keep learning 😊

[@subhbirajdar]

Interesting video for db performance

[@ravirajsaraganachari3038]

I request you to continue the same as it will help many in building their careers. Wishing you great success and may God bless you for your incredible efforts, sir. ❤

[@goodcourseavailable]

Amazing tutor on KZbin.. 1M subscribers soon 🎉

[@Javatechie]

Thank you so much buddy for your kind words 😊. Keep learning 😊

[@rameshbabub5243]

I didn't know we can do this, thanks for this tutorial

[@ravindrakushwahakrishna]

Thanks sir for everything

[@tufankarmakar4497]

Thanks for sharing such a usefull video

[@KenanSevinmedik-u5f]

Thank you brother. I love Java Techie!

[@skaftab3954]

Bro these are premium stuff. I am surprised by the number of subscribers.

[@anandnigade5886]

I was also searching for the same. Thank you so much 🎉

[@Rakeshcp-g7w]

Thanks for sharing 👍

[@VikashRai_07]

Thanks! 🙂

[@erbharat2022]

Thank you 🙏🏻

[@satyamsundaram-r4n]

Thanks❤🙏

[@GKK31]

Thanks for sharing

[@ALLinONE121]

Great 👍

[@henrivalencia21]

thank you.

[@karthikravisankar5608]

Could you please post a video on the jpa specification interface

[@girishputtaraju8581]

Hello Basat, Please make video for gRPC synchronous communication

[@siyamuddin]

Impressive

[@praveenkchowdam]

Hello bro . Your explanation is good . one request from my end. please create one springboot +react (crud application) with all the features like api gateway and spring security ,kafka , redis cache , postgres db . I already requested so many times in the comments . please make one video on that , it will be helpful for others also.

[@Javatechie]

Sure buddy will do that

[@praveenkchowdam]

@@Javatechie thank you. I am waiting 🙂

[@shubhamthakare1599]

please explain about Optimistic vs. Pessimistic Locking in Spring Data and thank you for this video

[@Javatechie]

Sure good suggestion 👍. Noted ✅️

[@joshipratik3381]

​@@Javatechie, Thanking you in anticipation.

[@azharmobeen]

Thanks for sharing but in Spring data jpa we have @Transactional(readOnly = true) and similary we have paggination as well. why we need to use QueryHint ? what's the main advantage ?

[@Javatechie]

Transaction ment to avoid data inconsistency buddy however Query hints will help to boost your query performance on the fly applying inbuilt support on query itself

[@vndprasadgrandhi4344]

Thank you very much sharing information bro..Plz plan java 9 to java11 series from your way and Waiting lot of persons same

[@veerraju8445]

using query hints,page size was set to 50 but in response we got all records?

[@rajesh.gundabathula]

HI Bro now a days every one discussing about AI and chat gpt will be in future what type of evolution can be happening in java.can we include AI in java for our daily work

[@vikrambaliga7241]

How long does the value stay in cache,also why did time out if time out was set to 2000, when the response 1029

[@tubemekala]

I also have same question why did time out if time out was set to 2000, when the response 1029?

[@Javatechie]

Guys, that's exactly what I mentioned. The response time may vary. For example, the first time I tried, it took over 2000 ms. However, after a restart, it took only 1029 ms on the second attempt. If you restart and retry again, the response time could exceed 2000 ms or drop below 1029 ms

[@Javatechie]

If no explicit cache duration is configured in your cache provider, the cache entries will remain until they are evicted due to memory constraints, manual eviction, or application restart.

[@vikrambaliga7241]

@@Javatechie Thanks Sir

[@girishvm2335]

Timeout is not required right technically Let it take the actual time as we optimised the method using queryhint know .

[@Anilkumar-reddy]

Good Video as always♥, one doubt here. In video iu mentioned in the quertHint annotatios as fetch size is 50 right. after calling the api, did u get the records in 1lakh++ or only 50

[@Javatechie]

No let me clear your doubts , fetchSize controls how many rows the JDBC driver fetches in one go from the database cursor but doesn’t limit the total records returned by the query. For example, with fetchSize=50, the driver fetches rows in chunks of 50, optimizing memory usage for large datasets. However, all rows matching the query will still be returned unless explicitly limited using setMaxResults() or a LIMIT clause. For instance, if a query matches 1000 rows, they’ll be fetched in 20 chunks of 50 but all 1000 rows will be returned unless otherwise restricted. Hope this make sense

[@Anilkumar-reddy]

@ Thank you for detail explaination👌👌🙌

[@girishrp9339]

Basat request you please answer this question Why introduced Java 8 static and default method in interface and abstract class already used it? Can you tell me real time example

[@Javatechie]

Girish i have covered this video on my interview QA series please have a look once , after watching if you are unclear then please feel free to let me know

[@yashwanthv1092]

Great content from you as usual. Thanks a ton. Can you make a video on how to optimise update, delete and insert queries.

[@Javatechie]

Okay 👍

[@ash-1908]

When we use Queryhint for saving query response to cache, if the data in database is always changing, how will it help ? Because the cache data will not be in sync if database data is changed right ?

[@Javatechie]

It will update once you try fetching the records . Not sure how it does will check and update buddy

[@weitanglau]

Can you make a Spring Data JDBC video? Simpler than JPA

[@Javatechie]

Okay sure will do that

[@karthiksundaram544]

🎉

[@girishrp9339]

Can do make video of jpa save performance. In real time am facing 15sec to save into 3tables using oneTOMany relationship with Eager loading

[@Javatechie]

Okay sure I will plan but can you elaborate your usecase what is the payload size you are persisting to DB is this in bulk or single nested payload ?

[@girishrp9339]

iterating one record at time hearder table 1 record Details table 3 records Under details child table 4 records 3 tables one-to-many relationship Please make eager and lazy loading I didn't understand others videos still confused when to use fetchType.Eager and Lazy. One interview asked didn't given proper example

[@Javatechie]

@@girishrp9339 thanks for clear picture let me try to reproduce this exact scenario and will update you buddy

[@thurlukulasekhar223]

Small doute if it taken 1029 but why it thorws exception 2000 limit time

[@Javatechie]

When first time I ran it might took more than 2 sec that's why we get error. Second time it took only 1029 ms So the fact is that it will varry , for example if i will run 5 times in my local every time it won't give you the same result buddy

[@XprimeX-q7l]

hey the fetched size was 50 but it bought 196504 records how? and where was cache?

[@Javatechie]

No what it does is , fetchSize controls how many rows the JDBC driver fetches in one go from the database cursor but doesn’t limit the total records returned by the query. For example, with fetchSize=50, the driver fetches rows in chunks of 50, optimizing memory usage for large datasets. However, all rows matching the query will still be returned unless explicitly limited using setMaxResults() or a LIMIT clause. For instance, if a query matches 1000 rows, they’ll be fetched in 20 chunks of 50 but all 1000 rows will be returned unless otherwise restricted.

[@RohitSingh-sd2hn]

i couldn't find your design pattern playlist, can you please post that playlist link.

[@RohitSingh-sd2hn]

finally can i get rid of redis cache ?

[@Javatechie]

Redis complete Playlist is there buddy just click on Playlist section of javatechie you will find everything . Do let me know incase still you are facing issues

[@akhill357]

Where's pagination implemented here, you got all records at once

[@Javatechie]

FetchSize will load chunk of records on batch on the fly buddy. That's what the magic

[@2RAJ21]

Thank you