More efficient retrieval of progress - Githubissues

smiggleworth / Quidjibo

A task worker library for .NET with an async pipeline.

Apache License 2.0

14 stars 5 forks source link

More efficient retrieval of progress #31

Closed johnallers closed 6 years ago

johnallers commented 6 years ago

Noticed a few things that might be helpful for retrieving progress efficiently:

Consider adding a READPAST hint to

https://github.com/smiggleworth/Quidjibo/blob/d27477da4f05d673f644157d952eb87e0942e049/src/Quidjibo.SqlServer/Scripts/Progress/LoadByCorrelationId.sql#L1-L3

This would be useful for scenarios where a high number of progress updates are being made.

Consider an index on CorrelationId to Quidjibo.Progress

https://github.com/smiggleworth/Quidjibo/blob/d27477da4f05d673f644157d952eb87e0942e049/src/Quidjibo.SqlServer/Scripts/Progress/Setup.sql#L1-L22