Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Level 1
mohamedriyasy58
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
mohamedriyasy58
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
mohamedriyasy58
Level 1

26-03-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

155 likes

Total Posts

241 posts

Correct Reply

141 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

155 likes

Total Posts

241 posts

Correct Reply

141 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

26-03-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

Answers (0)