Thread safe broken while fetching rows
--------------------------------------
Key: DNET-740
URL: http://tracker.firebirdsql.org/browse/DNET-740
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.8.0.0
Environment: Microsoft Windows .Net application
Reporter: Toni Martir
Assignee: Jiri Cincura
Priority: Minor
Also, in single thread there is a big performance issue in latest verion.
Steps to reproduce.
- Fetch rows using different FbCommands, same connection and transaction in
diferent threads, 5.1 working, 5.8 broken
- Fetch rows from any big table, by using FbCommand.ExecuteReader and
FbDataReader.Read, compare times 5.1 and 5.8
A simple windows forms is provided that attach to employee database, dropbox
link: https://dl.dropboxusercontent.com/u/54600297/WindowsFormsApplication1.zip
You can switch nuget package version to test the working version.
Tested on Firebird 2.5 and Firebird 3.0.1
Timed results on Debug and Release
Version 1 thread 4 threads
5.1 3 seconds 9 seconds
5.8 10 seconds random exception
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
