community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

Limmitations of Code Tables (in Alteryx Connect)

Alteryx Partner

Hi guys,

 

I'm interested in using the Connect to store, update and use a finit lists of possible values (eg. list of possible screw types produced by a specific company) in a large volume (I guess the best way to do it is to use the Code Table and Code Table Value types), and I'm wondering if there is any limmitations of this approach - such as the level of hierarchy, count of rows or lists, values itself, loading (updating) process, decreasing speed with an increasing number of rows etc.

 

I was't capable to test everything and haven't found such information about using Code Table and Code Table Values and Connect, co I'm asking this (quite likely) stupid and too general question.

 

I'm sorry for stealing your time and would be glad for any piece of information.

Thank you so much.

Alteryx
Alteryx

Hi @Kudrnac ,

 

there is no hard limit implemented, i.e. Connect should never tell you anything like "You have reached maximum of 1000 inputs". 

BUT your case is not what this feature has been build for. That means you will hit some limit at some point, mostly because the way how the code-table is done is that all the records are serialised into one field in the db. And such field of course has its limit of size. Plus while the number of records will grow, the work with them will become extremely ineffective since for every field, Connect needs to read the whole list to extract one field. 

This way it is super fast for the case it is build for - to have tens to hundreds records. But once you start to put thousands or even more there, it will stop to work in a timely manner. And at some point you will not be able to add anything. Such number of course depends even on the length of names of the records as the total size in kB matters. 

Vojta T., PM for Connect
Alteryx Partner

Thank you @VojtechT!

 

That is exactly what I wanted to know :-).