Performance regression between 7.10.1 and 8.0.1 -----------------------------------------------
Key: DNET-1042 URL: http://tracker.firebirdsql.org/browse/DNET-1042 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 8.0.1.0 Environment: Win10, FB 3.0.7 Reporter: Rand Random Assignee: Jiri Cincura The performance to read data dropped to half between 7.10.1 and 8.0.1. On 7.10.1 my test finishes with 11.14 s. On 8.0.1 my test finishes with 28.72 s. I have created this github project with the code demonstrating my issue https://github.com/Rand-Random/FbPerf Only this file contains code: https://github.com/Rand-Random/FbPerf/blob/main/FbPerf8/FbPerfTest.cs This *.cs file reads 1 million rows from a database containing 5 million records. You can find the used database 7-zipped as TESTPERF.7z in the root of the github project, the file FbPerfTest.cs also contains code how I created/filled the test database, in case it is relevent. The C# project FbPerf7 has the NuGet package for 7.10.1, while the C# project FbPerf8 has the NuGet package version 8.0.1. I am using BenchmarkDotNet for the performance tests, I added the results as images into the root of the github project. The perf7.jpg contains the result for the FbPerf7 C# project, and the perf8.jpg for the FbPerf8 C# project. Please be aware of the fact that the folder FbPerf7 only contains the *.csproj file and not a single *.cs file, this is because I am linking existing files from the FbPerf8 folder, I do this to avoid writing the test twice. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider