I have a web app using Dash and one of my callback fetches data using MS SQL Server and it leaves connections in sleeping mode and never closes.
A dev i found on github has a similar issue and there was a recommendation to use asyncio and aioodbc. I implemented that and it works locally but when deployed and does not work.
Is there a way to make a dash callback work with asyncio and aioodbc?
"we’ve been having some really good fun using FastAPI, so congratulations to the community on delivering such a marvel.
Issue is we use pyodbc DBAPI to connecto to MS SQL Server 2019 and that’s not possible to make any async calls from what I understand. So we end up seeing our users queued and sometimes even get timeouts."