Reading BLOB SUB_TYPE TEXT is very very slow
---------------------------------------------
Key: DNET-286
URL: http://tracker.firebirdsql.org/browse/DNET-286
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 2.5.1
Environment: VS2008 SP1, Windows Vista SP1, MS.Net 3.5, Firebird
Server 2.1
Reporter: Tao Lin
Assignee: Jiri Cincura
I have a blob text file like define like this:
HtmlChuck BLOB SUB_TYPE TEXT SEGMENT SIZE 80 NOT NULL,
My connection string define like this:
string connectionString = "Data
Source={0};Database={1};User=SYSDBA;password=masterkey;Dialect=1;Role=;Connection
lifetime=15;Pooling=true;Packet Size=4096;";
I use the 'HtmlChunk' to store html page so that I can display it in runtime.
The HtmlChuck value usually 8,000-10,000 bytes long. When I am using the latest
Firebird.net provider to load the table by DataReader, it took 30 seconds to
load 126 records. But if I change not connection to ODBC connection like this:
string connectionString = "DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA;
PWD=masterkey; DBNAME={0}:{1};
It took less than 1 second to load the same 126 records.
I think this is Firebird.net provider performance issue.
--
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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
