DataAccessPerformance
DataAccessPerformance copied to clipboard
aspnet
Benchmarks, prototypes and discussions for database access performance investigation
As commented by @bgrainger on email: > we'd want to use MySQL Server 8.0 with the new CLIENT_OPTIONAL_RESULTSET_METADATA flag (https://dev.mysql.com/doc/refman/8.0/en/c-api-optional-metadata.html, https://dev.mysql.com/worklog/task/?id=8134) to dramatically reduce MySQL protocol bandwidth usage from sending...
.NET Core 2.1 is going to bring new changes to `ValueTask` that are going to enable it to wrap simple awaitable objects that can be reused across multiple async operations:...
@bgrainger (from [MySqlConnector](https://github.com/mysql-net/MySqlConnector)) mentioned @neuecc has a lower-level data provider for MySQL called [MySqlSharp](https://github.com/neuecc/MySqlSharp) that focuses a lot on avoiding unnecessary allocations. We should consider adding a variation on our...
See this comment change and comment for context https://github.com/aspnet/benchmarks/commit/47946e46bfcbb6a53fe1f3f15117fab28ba03f87#commitcomment-27757823
Attendees: @ajcvickers @anpete @DamianEdwards @davidfowl @divega @roji @sebastienros Current areas of investigation: - #29 @sebastienros will look at ways to execute database-only (e.g. no web) tests in our benchmark harness....
@roji is now writing some benchmarks that don't actually use a database driver as a means to rule out low-level bottlenecks as the root cause for the differences we are...
This will improve our ability to compare and analyze the performance of the database access stack or networking stack in a reproducible way without "noise" from the web implementation.
_Attendees: @anpete, @divega, @geleems, @sebastienros, @vancem_ In today's meeting @vancem described an investigation the did several months ago of the TechEmpower Fortunes benchmark using SqlClient. Thanks for all the great...
Attendees: @roji @anpete @ajcvickers @DamianEdwards @sebastienros @saurabh500 @geleems @divega Today went through several points on the results at https://github.com/aspnet/DataAccessPerformance/wiki/Latest-benchmark-figures-for-PostgreSQL and a conversation we had with @stephentoub on possible additional optimizations...
Attendees: @roji @ajcvickers @anpete @sebastienros @divega @davidfowl @DamianEdwards @mikeharder Npgsql improvements on Fortunes for physical hardware on Linux: 60,000 rps - Npgsql Latest released 77,000 rps - Npgsql New release...