Very slow close of statement [execute SP] -----------------------------------------
Key: CORE-3982 URL: http://tracker.firebirdsql.org/browse/CORE-3982 Project: Firebird Core Issue Type: Bug Components: API / Client Library, Engine Affects Versions: 2.5.2 Environment: Win7 x64, i7-Q2670QM. Reporter: Kovalenko Dmitry Server Version :2.5.3.26543 [Windows, x64, SuperClassic] Client Version :2.5.3.26543 Database ODS :11.2 Database Dialect:3 ---------- [Test stored procedure] CREATE PROCEDURE SP_PAUSE_FETCH(N INTEGER, PAUSE INTEGER) RETURNS (ID INTEGER,DUMMY VARCHAR(32000)) AS DECLARE VARIABLE P INTEGER; DECLARE VARIABLE S INTEGER; BEGIN ID=0; DUMMY=''; P=0; WHILE(P<32000)DO BEGIN DUMMY=DUMMY||'A'; P=P+1; END S=0; WHILE(S=0)DO BEGIN P=0; WHILE(P<PAUSE) DO P=P+1; IF(ID<N)THEN BEGIN ID=ID+1; SUSPEND; END ELSE BEGIN S=1; END END END ---------- [/Test stored procedure] Scenario of API call 1. begin transaction 2. prepare and execute "select ID,DUMMY from SP_PAUSE_FETCH(1000,10000000)" 3. fetch one row 4. close statement <---- very slow operation. -- 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 ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel