search

rebus-org / Rebus.SqlServer

:bus: Microsoft SQL Server transport and persistence for Rebus
https://mookid.dk/category/rebus
Other
43 stars 42 forks source link

Lease transport specific indexes #55

Closed MrMDavidson closed 4 years ago

MrMDavidson commented 4 years ago

We did some performance testing (of the lease transport) ahead of migrating to the newest build. We found that these indexes are highly beneficial to performance of the lease transport which is currently using only the base SqlServerTransport indexes currently.

Rebus is MIT-licensed. The code submitted in this pull request needs to carry the MIT license too. By leaving this text in, I hereby acknowledge that the code submitted in the pull request has the MIT license and can be merged with the Rebus codebase.

mookid8000 commented 4 years ago

cool! 👍 it's out in Rebus.SqlServer 6.0.0-a7

I made a little test to check the difference before/after #55 – here are the results:

BEFORE:
*** Using LEASE-BASED SQL transport ***
1000 messages received in 6,5 s - that's 152,7 msg/s

*** Using LEASE-BASED SQL transport ***
10000 messages received in 56,3 s - that's 177,7 msg/s

AFTER:
*** Using LEASE-BASED SQL transport ***
1000 messages received in 2,0 s - that's 499,4 msg/s

*** Using LEASE-BASED SQL transport ***
10000 messages received in 41,2 s - that's 242,7 msg/s

Conclusion: Pretty awesome improvement!!

(the test is here 👉 TestSqlTransportReceivePerformance.cs)