[Firebird-net-provider] [FB-Tracker] Created: (DNET-320) DataAdapter.Update method is very slow when database is located on flash disks

[Yiannis B. (JIRA) <tr...@fi...>]

DataAdapter.Update method is very slow when database is located on flash disks
------------------------------------------------------------------------------

                 Key: DNET-320
                 URL: http://tracker.firebirdsql.org/browse/DNET-320
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.5.2, 2.5.1
         Environment: .NET Framework 2.0, VS2010, VS2008
            Reporter: Yiannis Bourkelis
            Assignee: Jiri Cincura


When the attached firebird database is located on a flash drive, the DataAdapter.Update method runs very slow when updating or adding new records. This is not happening on SANDISK CRUZER flash disk, but it is still slow.

I tested it with 2 flash drives, the APACER AH521 and the KINGSTON DT410 and it took around 30 seconds to insert 10 new records.

In the attached project modify the strConnectionString to point to a database located in a flash disk.
The database.fdb file is located inside the SlowFirebirdInsert folder.

Using exactly the same code and database schema, but the VISTADB database engine, inserting 10 records took around 2 seconds on the above flash disks.


-- 
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