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
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
