[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
|  
Report Content as Inappropriate

[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: 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Loading...