LiteDB -> SQL slowness

Published 3 years ago

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

0696a0b75c01a78d5ceb7a328c0e34a13e615efd
Anyone else notice anything?

0696a0b75c01a78d5ceb7a328c0e34a13e615efd.png

All Comments (5)

Published 3 years ago

How did you measure the metrics?

I will see if can replicate this.

michaelhanson1458

Published 3 years ago

That image I shared was from azure API management specifically.

Adam Driscoll

Published 3 years ago

Do your scripts write a lot of pipeline output?

Adam Driscoll
PowerShell Expert and Developer at Devolutions

michaelhanson1458

Published 3 years ago

Yes but I wouldn’t say its a lot of output for the pipeline. Mainly an AD user object with some other information. Host output is like ~20 lines.

Published 3 years ago

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?