Bigger Row Size Limit (currently 64k) [CORE755]

[firebird-automations]

Submitted by: marcgeldon (marcgeldon)

Votes: 5

SFID: 1411469#⁠
Submitted By: marcgeldon

Hello!

It would be a very good idea for Firebird to have a
bigger row size limit.

1 MB or more. Is that possible? Or is this already done
in Firebird 2.0 (I found nothing on the web).

Hope to hear from you soon.

Best wishes,

Marc

[firebird-automations]

Commented by: Alice F. Bird (firebirds)

Date: 2006-01-30 11:43
Sender: marcgeldon
Logged In: YES
user_id=1419303

It would be a very nice first step if it would be possible
to do SELECTs with a bigger row size limit.

[firebird-automations]

Commented by: Alice F. Bird (firebirds)

Date: 2006-01-25 13:27
Sender: dimitr
Logged In: YES
user_id=61270

It requires a major ODS change as well as enough code changes.
No, this has not been done in v2.0.

[firebird-automations]

Modified by: @pcisar

issuetype: New Feature [ 2 ] => Improvement [ 4 ]

assignee: Dmitry Yemanov [ dimitr ]

SF_ID: 1411469 =>

[firebird-automations]

Modified by: @dyemanov

priority: Major [ 3 ] => Minor [ 4 ]

Component: Engine [ 10000 ]

SF_ID: 1411469 =>

[firebird-automations]

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 10779 ] => Firebird [ 15166 ]

[firebird-automations]

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

[firebird-automations]

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Commented by: Julien Nabet (serval2412)

Hello,

Contributing a bit on LibreOffice, I noticed this bug https://bugs.documentfoundation.org/show_bug.cgi?id=127040 due to limited record size of Firebird.
Are there any update about the situation? More precisely, is there some plan to increase the max record size?
Indeed, I noticed on Firebird github source that src/jrd/val.h still contained:
const ULONG MAX_RECORD_SIZE = 65535

Regards.

[firebird-automations]

Commented by: @dyemanov

So far the limit is still the same. However, the underlying code changes are already made in the master branch, so it can be safely (I believe) increased in FB4. But I don't want to introduce this before the record compression is improved.

[firebird-automations]

Commented by: @hvlad

Julien,

could you think about converting that huge VARCHAR fields into BLOB's when migrating database ?