Which INT type is better to store whole numbers without affecting Database and Instance performance? | Community
Skip to main content
mohamedriyasy58
mohamedriyasy58
March 26, 2020
Solved

Which INT type is better to store whole numbers without affecting Database and Instance performance?

  • March 26, 2020
  • 1 reply
  • 2854 views

Hi,


I need to store whole number which range exceeds than the allowed range of INT(long). There is an another option to use BIG-INT (int64) for the large range of values, but seems it will affect schema and instance performance and also consumes a lot of storage. I need to use int64 in some cases without impacting on instance and schema performance. Kindky help me to resolve this issue.


Best Regards,

Riyas

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi Riyas,

 

In this case, this is more of a DB performance question versus Campaign.  That said, I'd suggest making note of your database type and version along with your operating system and then doing a web search on what is the recommended value type based on your database, DB version and OS.

 

Regards,

 

Craig

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
March 26, 2020

Hi Riyas,

 

In this case, this is more of a DB performance question versus Campaign.  That said, I'd suggest making note of your database type and version along with your operating system and then doing a web search on what is the recommended value type based on your database, DB version and OS.

 

Regards,

 

Craig

Terms & ConditionsAccessibility statement

Loading footer...