Back

[SOLVED] Attribute Limit Exceeded

  • 0
  • Databases
  • Web
Kevinkevinkevin
5 Jun, 2023, 15:58

When I try to create an attribute , it's showing attribute limit exceeded

TL;DR
Solution: The issue was resolved. The attribute was created successfully. The suggestion was made to use VARCHAR instead of CHAR as it takes up less space. It was also mentioned that if the length of the attribute exceeds 16383, the type TEXT should be used instead of VARCHAR to save space. It was also noted that if the attribute length is set to a high value, it could result in exceeding the attribute limit. It was advised to consider if a shorter length would suffice to avoid hitting the attribute limit. Additionally, it was mentioned that providing a default value for the attribute can also help in avoiding this issue.
Drake
5 Jun, 2023, 15:59

ya...this is a limitation of the underlying db. do you really need somethign that is 10,000 or is longer okay?

Kevinkevinkevin
5 Jun, 2023, 16:00

nope , I just give it some default value. I didn't realize it. Thanks for pointing out

Drake
5 Jun, 2023, 16:02

try longer than 16383. under 16383, a VARCHAR is used which takes up space in the row. starting at 16384, TEXT is used which is a pointer and takes up less space

Kevinkevinkevin
5 Jun, 2023, 16:06

that's so cool. I am just learning about varchar. But why go with the varchar in the first place if it takes more space

Binyamin
5 Jun, 2023, 16:16

Varchar will take a less space as it will limit the size of the able to inserted into that attribute.

P.s. Char it's like Varchar but the length is not varying. the final different will be matter for indexing purposes

Kevinkevinkevin
5 Jun, 2023, 16:19

oh okay got it. Thank you

Kevinkevinkevin
5 Jun, 2023, 16:19

The attribute is getting created now. You can close the issue

Drake
5 Jun, 2023, 16:35

[SOLVED] Attribute Limit Exceeded

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more