[FB-Tracker] Created: (DNET-740) Thread safe broken while fetching rows

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[FB-Tracker] Created: (DNET-740) Thread safe broken while fetching rows

JIRA tracker@firebirdsql.org
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:
         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
[hidden email]