Select slowing down
-------------------
Key: CORE-4628
URL: http://tracker.firebirdsql.org/browse/CORE-4628
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.3
Reporter: Attila Molnár
Priority: Minor
Attachments: test.gbk.zip, test.sql
Hi!
See attached files.
Running the SQL you'll see that SELECT statement in the loop block slows down
by every iteration (dSelect).
Updata (dUpdate) and fetch (dFetch) times are stable.
Runtime statistic shows what you expect
IR : 87121 (form the slowing down select )
NIR : 87121 (from the for select)
UPD : 87121 (from the update)
So looks like index reading slows down.
This is a bug and can be fixed, or this cames from inner desing and works as
expected?
Thank you!
--
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
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
