Maximum Row Size

REST
1

I received the error = {“code”:44,“message”:“Maximum row size reached”}

What is the value for the max. row size?

2

Hi, Roy.

I believe it depends on the column type. Can you show the steps to reproduce this error so we can make the message more informative?

3

Hi, Roy!

Looks like you’ve already asked this question http://support.backendless.com/t/internal-server-error-when-saving-data-objects-in-text-columns#comment-3931
We’ll update the error message to be more informative in the next release.

4

I didn’t save the request that caused this problem. If I see this problem again, I will save off the entire request and send it to you.

5

Although I don’t have the exact data setup, I think this error was created by doing the following:

  1. I added a row with no problem.
  2. Then I updated additional columns from the same row that I previously created. This is when I saw the error: {“code”:44,“message”:“Maximum row size reached”}

Schema was using - 8 TEXT columns, 10 String columns, and 11 Integer columns.

The update takes into account the current row size?

6

Yes. The maximum row size is 8126 bytes. The size of your own data (excluding our system fields, like objectId and so on) should not exceed 8037 bytes.
TEXT column takes no more than 788 bytes ( you can save more data in TEXT column but it won’t be saved in the column itself but in the other place ); in other words, only first 788 bytes are counted. This means that you can have at most 10 TEXT columns in one table, and then you’re left with 157 free bytes (so you can store a 157 symbol STRING).

7

Thanks for the info