HangfireIO / HangfireIO/Hangfire

Idea to improve Sql server query performance with timestamp column

Open
#1,996 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
10.1k
Forks
1.8k
Avg merge
1h 19m
Merged PRs (30d)
1

Description

A timestamp column is an automatically increased value (db) globally unique binary value, on every row update, maintained by the SQL Server engine.
Since the timestamp column can be indexed it could potentially allow much faster querying for queries of the type "give me changed rows since last check", by adding a where condition in tsql pseudocode style `WHERE row.timestamp.ToBinary() > @LASTCHECKED`
Is it worth investigating with performance testing of some large datasets ?

Contributor guide

Open the contributing guide

Research direction

The issue names no files, tests, or entry points. Begin with performance testing on large datasets using SQL Server queries for changed rows, and determine whether an indexed timestamp column provides a meaningful improvement over the current approach.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
databases, performance
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.