Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
firebird-automations opened this issue Jan 21, 2006 · 12 comments
Open

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

firebird-automations opened this issue Jan 21, 2006 · 12 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @pcisar

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

assignee: Dmitry Yemanov [ dimitr ]

SF_ID: 1411469 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

Component: Engine [ 10000 ]

SF_ID: 1411469 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Commented by: @hvlad

Julien,

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants