Issue Details (XML | Word | Printable)

Key: CORE-3157
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Daniel Bauten
Votes: 0
Watchers: 4
Operations

If you were logged in you would be able to see more operations.
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. File CommentOnParameter.7z (2.65 MB)

Environment:
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: Ascending order - Click to sort in descending order
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.

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