How does the following SqlServerStorageOptions work?

Tags: #<Tag:0x00007f4998b40878>


I have been experiencing delay about 10 seconds after enqueing the jobs. I noticed that I can set the QueuePollInterval to 0 and SlidingInvisibilityTimeout to make the job processing faster.

Can anyone actually explain how they work? Is the sliding option like a auto poll interval selector? Will it make frequent calls to the database?

    .UseSqlServerStorage("db_connection", new SqlServerStorageOptions
        CommandBatchMaxTimeout = TimeSpan.FromMinutes(5),
        SlidingInvisibilityTimeout = TimeSpan.FromMinutes(5),
        QueuePollInterval = TimeSpan.Zero,
        UseRecommendedIsolationLevel = true,
        UsePageLocksOnDequeue = true,
        DisableGlobalLocks = true