I require assistance optimizing an existing Spring Boot API developed with a reactive stack. The API handles inventory management and was created using Spring WebFlux, Spring Data R2DBC with PostgreSQL, and Kotlin coroutines. Neon is utilized as the cloud provider. Currently, some database queries designed to retrieve large volumes of data are experiencing inconsistent performance issues. Queries that previously completed within 1 second are intermittently stalling and taking an excessive amount of time to return results. Even with no user load, lightweight queries will randomly hang and require manual cancellation from the database statement pool. The current database connection implementation or query design may be leading to bottlenecks under certain conditions. An expert Reactives Spring developer is needed to analyze the existing codebase and API calls, identify potential points of failure or inefficiencies, and implement solutions such optimize database utilization and handling of long-running queries. The goal is to achieve predictable, high-performance response times for all API endpoints and resolve any infrastructure constraints causing intermittent query failures.
Add Service Pages & Boost SEO Category: Content Development, Content Writing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Web Development, Web Design, Website Optimization Budget: £250 - £750 GBP
Site e Redes para Consultório Category: Article Writing, Content Creation, HTML, Link Building, SEO, Social Media Management, Web Design, WordPress Budget: $250 - $750 USD
SEO-Optimized Blog Post Series Category: Article Rewriting, Article Writing, Blog, Blog Writing, Content Writing, Keyword Research, SEO, SEO Writing Budget: £250 - £750 GBP
Animated Background Replication Category: Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: £10 - £50 GBP