ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Is there any performance impact if changing the data types for many columns ?

saisaranv
7 - Meteor

Hello All,

 

I had a very large data set and is there any performance improvement if I change data types ? 

 

Ex: instead of int16 can I use bytes ? like that,

2 REPLIES 2
mceleavey
17 - Castor
17 - Castor

Hi @saisaranv ,

 

the short answer is no, unless the change in data type increases the number of reserved characters. For example, if you have a column with one digit values, don't change it to be a string with 50000 characters. 

Otherwise, no, you're fine.

 

M.



Bulien

saisaranv
7 - Meteor

I have verified in official documentation page, with data type changes we can save memory and will improve performance with data types in case of large data sets.

Labels
Top Solution Authors