Discussion cleanup network and network_addresses table in /etc/pihole-FTL.db

[jpgpi250]

@DL6ER

*) In the other discussion, @jpgpi250 pointed out that Windows adds a new temporary IPv6 PE every two hours. This makes 12 a day, 84 a week, roughly 4,400 a year. This is per-device but assuming 24/7 operation so likely worse than you'd see in reality.

I never said that on a windows 10 machine the temporary IPv6 address changes every two hours. The 2 hour change is something I experimented with on a Linux machine, see this topic.

On a windows machine, the temporary IPv6 address changes every time you reboot OR once a day (if you leave the machine on), unless you change the values in the registry (not tested). You can confirm this by running the command netsh interface ipv6 show privacy, which will show you, among other things Maximum Preferred Lifetime: 1d

@DL6ER

New plan to get something everyone can hopefully get happy with: The maximum age of addresses can now be controlled though the new MAXNETAGE config option. It defaults to the value of MAXDBDAYS . The new option MAXNETAGE can be set to zero to avoid any auto-cleaning.

great solution, thank you for this.

@_FailSafe

I think you are missing the value in what I proposed in that request

My native language is not English, this may lead to some confusion from time to time. The opposite of what you understood is true, I encourage DL6ER to make these kind of changes, even if they will only be used by a few users. I have been running another test branch my self, the one that allows regexes such as .*;querytype=!A, and even though I assume very few users will ever use this, I'm an absolute fan of these kind of features / enhancements, even the ones I will not use myself.