I have large gaps in NIDs on my site. Should I clean it up?

 
Sean Reiser

I have large gaps in NIDs on my site. Should I clean it up?

Cross-posted from Stack Exchange.

So, I’m doing some delayed maintenance on this site.  You know, removing modules I don’t need anymore, cleaning up taxonomy, etc, etc.  Technical debt on this site because you know what they say about cobbler’s children and shoes.  When I decide it’s time I’ll be move the site to D9, I want to make the transition smooth.  The site has been around a while.  It was originally a Drupal 4.7 site which has been upgraded to 5, 6, 7 is currently a D8 site.  

So enough preamble, back in the site’s D5 days I had 4 Drupal sites  that I merged into this site.  Since there wasn’t a MigrateAPI 12 years ago, I renumbered the NIDs inside the source sites and then copied the database records into the target site.  In case I needed to debug things, I left gaps between each of the site’s modes (I added 2000 to the NIDs from siteA, 4000 to the NIDs from siteB, etc) so I could easily tell where the nodes came from.  

This is worked and the merged site has been chugging along for over a decade.  I’ve come o a point where the system has ~3,000 nodes but the highest NID is approaching 11,000.  I don’t see any risk here, I’ve worked on much larger sites.  I’m in no danger of exceeding the max number of NIDs anytime soon. 

My question is, Is there any benefit to compressing the NIDs (probably by migration to fresh Drupal installation)?  I don’t see one, but I might be missing something that someone else can see.

Sean Reiser

Hi I'm Sean Reiser

#NewYorker #DrupalDeveloper #InfoSec #Photographer #GEEK #Whovian #MYSTie #LetsGoYankees #LongSufferingJetsFan #NAKnight #Quinquagenarian #CommitAwesome

I'm a 51 year old Flushing, Queens based technologist who specializes in developing, supporting and maintaining websites built in Drupal.  I am an avid photographer and all around geek.  Feel free to look at my blog, or head to my home page to learn more about me.