Is there a suggested data type for Element Table Primary Keys?

Solved973 viewsdriver development primary key
4
0 Comments

Hello Dojo,

We are currently retrieving a large amount of data that we are going to be saving to a table. These entries all have unique names (no longer than 20 characters long). We are estimating having at least 500k rows. Is there a benefit to assigning unique Numeric Text Primary Keys or is the name in String format just as efficient?

Jan-Klaas Kesteloot [SLC] [DevOps Advocate] Answered question 3rd May 2023

2 Answers

2
7.99K 0 Comments

Hi Gabriel. I think it's best to simply use the names that you already have as keys, especially since they are relatively short. The keys are stored in the table as strings anyway, even when they are numeric.

Assigning numbers to the entries probably means that you'll need to store a mapping somewhere. Setting, getting and updating that mapping will also have an impact on performance.

Gabriel Borges [SLC] [DevOps Advocate] Selected answer as best 28th April 2023
You are viewing 1 out of 2 answers, click here to view all answers.