topic ObjectID increments 400 at a time in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/objectid-increments-400-at-a-time/m-p/189028#M7527 <HTML><HEAD></HEAD><BODY><P>These new forums are taking time to get used to. Forgive that I'm asking a question I almost certainly bet has been asked before; I can't find anything.</P><P></P><P>I'm Applying Edits via.&nbsp; Flex and JavaScript REST calls to a PostgreSQL server.&nbsp; Each group of added records will have congruent ObjectIDs&nbsp; (1,2,3,4)&nbsp; but the next addition will jump by 400&nbsp; (401,402,403...).&nbsp; and so forth.&nbsp; I'm into the tens of thousands already for only a few hundred records.</P><P></P><P>I read somewhere back in the days of undergrad that this has to do with optimization by reserving groups. (Kind of like how some file systems spread stuff across a disk maybe?). </P><P></P><P>1. Can I adjust/disable this functionality?</P><P>2. Does it ever back-fill in the gaps?</P><P>3. If so, when does it do this?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 26 Aug 2014 14:31:29 GMT AndrewBlakey 2014-08-26T14:31:29Z ObjectID increments 400 at a time https://community.esri.com/t5/arcgis-enterprise-questions/objectid-increments-400-at-a-time/m-p/189028#M7527 <HTML><HEAD></HEAD><BODY><P>These new forums are taking time to get used to. Forgive that I'm asking a question I almost certainly bet has been asked before; I can't find anything.</P><P></P><P>I'm Applying Edits via.&nbsp; Flex and JavaScript REST calls to a PostgreSQL server.&nbsp; Each group of added records will have congruent ObjectIDs&nbsp; (1,2,3,4)&nbsp; but the next addition will jump by 400&nbsp; (401,402,403...).&nbsp; and so forth.&nbsp; I'm into the tens of thousands already for only a few hundred records.</P><P></P><P>I read somewhere back in the days of undergrad that this has to do with optimization by reserving groups. (Kind of like how some file systems spread stuff across a disk maybe?). </P><P></P><P>1. Can I adjust/disable this functionality?</P><P>2. Does it ever back-fill in the gaps?</P><P>3. If so, when does it do this?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 26 Aug 2014 14:31:29 GMT https://community.esri.com/t5/arcgis-enterprise-questions/objectid-increments-400-at-a-time/m-p/189028#M7527 AndrewBlakey 2014-08-26T14:31:29Z Re: ObjectID increments 400 at a time https://community.esri.com/t5/arcgis-enterprise-questions/objectid-increments-400-at-a-time/m-p/189029#M7528 <HTML><HEAD></HEAD><BODY><P>you can reset autoincrement column. In sql server, for instance, you can use <A href="http://msdn.microsoft.com/en-us/library/ms176057.aspx" title="http://msdn.microsoft.com/en-us/library/ms176057.aspx">DBCC CHECKIDENT (Transact-SQL)</A>&nbsp; </P></BODY></HTML> Tue, 26 Aug 2014 15:09:43 GMT https://community.esri.com/t5/arcgis-enterprise-questions/objectid-increments-400-at-a-time/m-p/189029#M7528 nicogis 2014-08-26T15:09:43Z