List ID column data object size

Question

Can anyone tell me what type of Integer the LIST ID column is on a list?

We're using a list to store data records that we refresh the entire set every 12 hours. It's about 4500 rows so I will eat up 9000 IDs a day.

Want to make sure that column won't explode! :)

eirikb · Accepted Answer · 2012-09-18 20:36:48Z

0

According to MSDN SPListItem.ID is an 32 bit integer, which should be capable of holding values up to 2,147,483,647.

(2147483647 / 9000) * 1 day = 653.291 years

answered Sep 18, 2012 at 20:36

eirikb

7,4255 gold badges36 silver badges67 bronze badges

Actually ID starts on 1 and not 0 so it might actually be 2147483646, unless it's actually saved as ID-1 and presented / referenced otherwise
– eirikb
Commented Sep 18, 2012 at 20:44
Excellent! Thanks so much for finging that. I had looked, but couldn't put my finger on it!
– Paul Duer
Commented Sep 19, 2012 at 11:58

Add a comment |

1 Answer 1