Issue Details (XML | Word | Printable)

Key: CORE-1658
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Avoid memory consumption of <page size> bytes per every temporary blob

Created: 19/Dec/07 09:11 AM   Updated: 09/Oct/12 03:57 PM
Component/s: Engine
Affects Version/s: 2.1 Beta 2
Fix Version/s: 2.5 Alpha 1, 2.1.4

Time Tracking:
Not Specified

Issue Links:
Relate

Target: 2.5.0


 Description  « Hide
Every blob contains a buffer of <page size> bytes allocated out of the engine heap, even if its size is actually smaller. For example, this query:

select cast('a' as blob sub_type text) from <really big table>

can easily cause a system swap or even a FB server crash due to out-of-memory condition.

This was discussed in fb-devel. I think we should find a way to reduce memory consumption for small temporary blobs, or maybe always store the level-0 blob data in the temporary space instead of the heap.

I'm scheduling this RFE for v2.5.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.