Issue Details (XML | Word | Printable)

Key: DNET-740
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Minor Minor
Assignee: Jiri Cincura
Reporter: Toni Martir
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
.NET Data provider

Thread safe broken while fetching rows

Created: 14/Mar/17 03:41 PM   Updated: 29/Mar/17 12:16 PM
Component/s: ADO.NET Provider
Affects Version/s:
Fix Version/s: None

Environment: Microsoft Windows .Net application
Issue Links:

 Description  « Hide
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:
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura added a comment - 29/Mar/17 12:16 PM
The link does not work. And anyway, there was never a claim about any thread safety for FbCommand etc. classes, in fact quite contrary.