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