According to the DB product people, y ou are limited to 500KB per record. There are no limits to number of fields you can have.
But I have 60 KB file in one cell and after few records it shows error ‘pay load too large’. It suggests that there is some limit either on account of number of characters or total file size in a row.
If you need further details or clarification, I would recommend contacting the Wix support team , as they know best.
Yes I asked Wix support team.
I will face the same issue in the future, as the users will slowly be adding data over time for one specific of my collections. So to overcome the data limitation, I will recreate another item that is referred to the previous one that achieved the limitation.
Hint : For me, it works, as each field has an abstract sense of time. Meaning that each field refers to a specific month, and therefore the data in the field “March” is input before then the data in “April”.
Step 1)
I have an item with title “myItem” that reached 500KB limit any day in February (“February” field).
Step 2)
I recreate another item that refers to the previous one. for the reference, I use the same title, and In the title, I add the name of the field where the limit happened, between the title and the name field I use “_” as a limit identifier for step 3. And finally, delete all the data in the field where I reached the limit and copy it in the new row, this is to overcome the overlapping of data.
Step 3)
Now I want to query the object “myItem” as I want to know all of its data. So I make a query where the title has some of the characters “myItem”. Then with regex, I get the “_” limit character. Therefore so far I can know that one query object is the initial one and that the other object is the continuation. And thanks that I put the name of the field in the title, I can continue updating the item from that field onwards.
This is an easy way to overcome the data limitation per row, without changing your data fields collection structure or your code structure in the backend and front end. It’s not ideal but it works. You would have to analyze your own project and idealize, if you can make something similar.
cheers
Do images/audio/video fields contribute to this limit?