Max Text Field Length

3030
3
08-18-2015 09:37 AM
Highlighted
MVP Regular Contributor

I have a layer in SDE Feature Class that I need to expand the text length.

I currently have 600 but I need to expand it to 1500.

According to ArcGIS Help 10.1 I can expand it to 2,147,483,647.

I am afraid that it will slow down the database and webservice.

I was wondering if anyone has field lengths 1000 or bigger and how your database handles it.

Thanks

Reply
0 Kudos
3 Replies
Highlighted
MVP Regular Contributor

Are you in Oracle or SQL Server? What version?

Reply
0 Kudos
Highlighted
MVP Regular Contributor

SQL Server version 2012

Reply
0 Kudos
Highlighted
Regular Contributor

Hey Rickey could you keep the field length at a shortened name, and then add the long name as an alias?  I do not know if this would have an effect on the performance as well.  In earlier versions of geodatabases we were limited to the number of charters in field names, and this was a way to get around that limitation.  I am not sure if the database would look at the alias differently from the actual name.  Thank you.

Reply
0 Kudos