|
From: Yiannis B. (JIRA) <tr...@fi...> - 2010-06-01 23:00:37
|
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
|