Migrated from using the LiteDB to using SQL hosted in azure. My APIs that invoke scripts seemed to double in execution time which is a bit concerning at scale. I expected a bit of latency slowness but not 2x.
The top 3 are when the server is using azure and the bottom 3 are using the local LiteDB
We switched from LiteDB to SQL. I have a bunch of dashboards that rely on very large pipeline output from scripts to drive tasks. Are there any performance recommendations that we should consider?