Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Thread safe broken while fetching rows [DNET740] #682

Closed
firebird-automations opened this issue Mar 14, 2017 · 3 comments
Closed

Thread safe broken while fetching rows [DNET740] #682

firebird-automations opened this issue Mar 14, 2017 · 3 comments
Assignees
@cincuranet
Labels
component: ado.net provider priority: minor resolution: cannot reproduce/incomplete type: bug

Comments

@firebird-automations
Copy link

Submitted by: Toni Martir (tonimm)

Is related to DNET748

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
@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is related to DNET748 [ DNET748 ]

@firebird-automations
Copy link
Author

Commented by: @cincuranet

The link does not work. And anyway, there was never a claim about any thread safety for FbCommand etc. classes, in fact quite contrary.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@cincuranet cincuranet

Labels
component: ado.net provider priority: minor resolution: cannot reproduce/incomplete type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@cincuranet @firebird-automations