[#CORE-3157] COMMENT ON PARAMETER - Statement leads in a consumption of 1.7 GB RAM and a runtime of more than 1 Minute

Firebird Core

COMMENT ON PARAMETER - Statement leads in a consumption of 1.7 GB RAM and a runtime of more than 1 Minute

Created: 05/Oct/10 07:51 AM Updated: 04/Feb/11 01:09 PM

Component/s:

Engine

Affects Version/s:

3.0 Initial, 2.5.0

Fix Version/s:

2.5.1, 3.0 Alpha 1

Time Tracking:

Not Specified

File Attachments:	1. CommentOnParameter.7z (2.65 MB)
Environment:	« Hide Firebird 2.5.0.26074 x64, Windows 7 Professional 64-Bit (German), 4 GB RAM Show » Firebird 2.5.0.26074 x64, Windows 7 Professional 64-Bit (German), 4 GB RAM

Planning Status:

Unspecified

Description

« Hide

Adding a parameter description to a stored procedure leads (e.g. in attached database) in a memory consumption of 1.7 GB an a runtime of about 1 minute 15 seconds.

To reprocude, please do the following.

1. Extract CommentOnParameter.7z (please note: file is password protected; please mail to Daniel.Bauten(a)hksinformatik.de to obtain the password).

2. Use the following statement (runtime on my system: 1 minute 15 seconds).

COMMENT ON PARAMETER CHK_A_IN_CTR.AUTOSREF_FREF IS
'Test';

3. Use the following syntax (runtime on my system: 62 ms).

DESCRIBE PARAMETER AUTOSREF_FREF PROCEDURE CHK_A_IN_CTR
'Test';

Feel free to contact me if you have further questions about this issue.

Thanks in advance for fixing this. ;-)

Daniel

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Adriano dos Santos Fernandes added a comment - 24/Oct/10 12:06 AM

I've asked the reported for the database password, but didn't got it.

[ Permalink | « Hide ]

Daniel Bauten added a comment - 25/Oct/10 05:42 AM - edited

I haven't received any password request - probably "lost in spam". Sorry, Adriano.

I sent an email to you some minutes ago containing the needed password (Subject: "FB-Tracker ~~CORE-3157~~ - password"). Please let me known if this email won't arrive.

Daniel