Have you tried implementing caching mechanisms to store frequently accessed data locally? This can significantly reduce the time it takes to fetch data from the cloud.Another approach could be to review your database schema and ensure it's optimized for the types of queries your application frequently makes. Sometimes restructuring tables or using more efficient query techniques can make a noticeable difference in performance.If you're still hunting for solutions, I recently came across a method on
how to migrate from Sage 100, which might provide some useful insights into optimizing database performance. Exploring different strategies and possibly consulting with experts in database performance tuning could also be beneficial.