We are using SQL transport with NSB 5, Want to understand few details with respect to SQL transport & performance. I have gone through documents at https://docs.particular.net/transports/sql/?version=sqltransport_2
NSB execute below query to poll queue.
WITH message AS (SELECT TOP(1) * FROM QueueName WITH (UPDLOCK, READPAST, ROWLOCK) ORDER BY [RowVersion] ASC)
DELETE FROM message
OUTPUT deleted.Id, deleted.CorrelationId, deleted.ReplyToAddress,
deleted.Recoverable, CASE WHEN deleted.Expires IS NOT NULL THEN DATEDIFF(ms, GETUTCDATE(), deleted.Expires) END, deleted.Headers, deleted.Body;
- As per document mentioned above, polling intervel is one second,
1.1 Does it mean each endpoint can read one message per second ? or its depends on number of thread or value of MaximumConcurrencyLevel ?
1.2 can we reduce polling interval to milliseconds ?
Ultimate goal is to process more number of messages parallel, please suggest on same.