Struggling to update/insert 100000 records into postgresql in under 20 seconds

Summary The issue at hand is optimizing batch updates in a PostgreSQL database using Spring Boot. The current implementation using jdbcTemplate.batchUpdate takes around 2 minutes to update 100,000 records, which is unacceptably slow. The goal is to achieve batch updates in under 15 seconds. Root Cause The root cause of this issue is likely due … Read more

Spring WebFlux .doOnSubscribe & .doFinally. Is this race condition possible, if so, how to fix it?

Summary The question revolves around the potential race condition in the provided Spring WebFlux code, specifically between the .doOnSubscribe and .doFinally methods. The concern is whether it’s possible for .doFinally to execute before .doOnSubscribe, leading to a situation where a subscription instance is not properly removed from the SUBSCRIPTIONS map. Root Cause The root cause … Read more

Experiences frequent video call drops and audio loss specifically on iOS devices

Summary The WebRTC platform at https://dexinfra.netlify.app/ is experiencing frequent video call drops and audio loss specifically on iOS devices. This issue is reproducible on the latest iOS versions using Safari, but works fine on local development, Android, Chrome, Firefox, and non-iOS browsers. Root Cause The root cause of this issue can be attributed to several … Read more