Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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