Spider Strategies Blog

The latest news about our company and software

Another great feature introduced in 2.8 is the ability to lock note changes in addition to metric value changes after a certain amount of time. Both of these are set per calendar in the Administration section. Just like the ability to edit values, notes will always be editable by application administrators.

You may have noticed that things have been a little quiet over here at the Spider Strategies blog. We've been hard at work on a major new software release that isn't quite ready to announce yet. Until then, I have more than a few exciting things to share about version 2.

I'll be posting here once or twice a week until I'm able to work though our backlog of new functionality announcements. As you're about to find out, we've been busy.

The SQL Server 2100 parameter limit is a pain to code around when selecting lots of rows by ID and using batches of parameterized queries doesn't seem to perform very well.

This performance study shows that you should definitely stop using batched parameterized queries for selecting rows by ID. They should be replaced with a temporary table approach for large batches, or constructed SQL strings if temporary tables prove unworkable.

In version 2.8 there's a new equation you can use for calculated metrics called “Period to Date.” You can use this to create metrics with values based on rolling sums of other metrics’ values or thresholds. For example:

TD(Quarterly,123)would result in a quarter-to-date sum for metric 123's actual value.