I'm in my third year at university and I'm currently applying for internships. I have some projects that I'm planning to deploy, but I'm facing issues with performance, especially since they run very slowly when tested with a lot of data and concurrent users. My tech stack includes Java and Spring. I've experimented with Hikari connection pooling and caching, but I'm not sure I'm using them optimally. I would appreciate any suggestions on resources or books that could help me improve.
I've used K6 for load testing, but I found that the AI tool I uploaded my files to wasn't very accurate. Even with implementing caching and tweaking the database connections, the performance improvements have been minimal. I also learned that making two database queries in one method can lead to bad performance, so I've optimized to use just one query, which did help a bit. Any additional advice would be great!
2 Answers
It's awesome that you're diving deep into load testing and optimizing your queries! You're on the right track. Make sure to explore proper indexing and avoid heavy joins when possible, as these often create bottlenecks. Sometimes, the issue might not be with the database but rather with how the application processes data. Profiling your app during K6 tests could reveal some surprises that could lead to further optimizations.
I totally understand how frustrating it can be to find resources that are up-to-date. While books can help, don't forget online resources! Websites like Pluralsight and Udemy have many good courses on web development and performance optimization. If you're looking specifically for books, try "Java Performance: The Definitive Guide" and "Spring in Action". They cover performance-related aspects well!
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically