Simple query very slow on table with blob sub_type 0
----------------------------------------------------
Key: CORE-5086
URL: http://tracker.firebirdsql.org/browse/CORE-5086
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.5
Environment: Windows 7 FlameRobin
Reporter: Corey Marques
I have a table with two columns
CREATE TABLE ARTRANS
(
RECORDID Integer NOT NULL,
DESCRIPTION Blob sub_type 0
);
There is also an index on the table
CREATE UNIQUE INDEX IDX_ARTRANSRecID ON ARTRANS (RECORDID);
There are ~246,000 records
For this test, each blob had 20 bytes.
The following query takes 20 seconds
SELECT a.RECORDID FROM ARTRANS a
Changing the field type from blob to text fixes it.
Here is the output from FlameRobin:
Preparing query:
SELECT a.RECORDID
FROM ARTRANS a
Prepare time: 20.008s
Field #01: ARTRANS.RECORDID Alias:RECORDID Type:INTEGER
PLAN (A NATURAL)
Executing...
Done.
13257 fetches, 0 marks, 76 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 0 index, 6552 seq.
Delta memory: -19204 bytes.
Total execution time: 20.025s
Script execution finished.
--
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
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
