Skip to content
This repository has been archived by the owner on Feb 26, 2021. It is now read-only.

Standardized ADO.NET provider benchmarks #37

Open
roji opened this issue Mar 20, 2018 · 2 comments
Open

Standardized ADO.NET provider benchmarks #37

roji opened this issue Mar 20, 2018 · 2 comments

Comments

@roji
Copy link
Member

roji commented Mar 20, 2018

To facilitate comparison of provider performance and and especially to help zero in quickly on problematic areas, we could set up a standardized, cross-provider ADO.NET benchmarking suite.
This would be a set of BenchmarkDotNet benchmarks that would test common, standardized scenarios and provide a clear view of where each provider is on every operation.

This could be a published nuget that each provider extends (pros: customization, disabling of certain scenarios, adding of others) or one repo where all providers are included (pros: easier to produce a simple, clear comparative report such as https://github.com/dotnet/corefx/issues/7810#issuecomment-346109151).

What do you think?

@bgrainger, @sebastienros, @divega, @ajcvickers, @anpete

@niemyjski
Copy link

I think this would be really good to have. Would this cover more common usages of how providers are used as well? I think one scenario that should be looked at is at using DataTables (filling / consuming). I've seen a ton of legacy code over the years that uses data tables.

@roji
Copy link
Member Author

roji commented Mar 21, 2018

@niemyjski DataTables aren't really part of the ADO.NET provider - they're a layer above it, utilizing the provider underneath a bit like a loosely-typed micro-O/RM. So I don't think it would make much sense to benchmark that...

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants