Device IDs in Home Center - Reclaim or Cleanup unused IDs?

[chaicka 195]

After almost 2 years running Home Center 2 and a vast number of firmware releases, the device IDs have been sequentially increasing with every new inclusion of devices. In my setup, actual number of z-wave devices is around 40-50 (didn't actually count) but the device IDs now runs at 77x, largely due to many many inclusion and exclusion and re-inclusion of devices.

 

Is there anyway to clean up the unused device IDs and reclaim them for use?

Does the sequential device IDs, even unused ones, increase the database size or table size? If so, what is the performance impact?

 

While HC2 is significantly more powerful and the impact may not be significant, how about the same set of questions/assessments on HCL?

 

 

 

In my humble opinion, it may not be causing harm or hurt now but it is always good to be proactive and start thinking of a game plan for database housekeeping and optimisation - something typical programmers/developers are poor at or overlook while operational folks are familiar with.

[Sankotronic 2,370]

I agree with you that database housekeeping and optimization is important. I just hope that deleting of devices after making backup is not part of that optimization

Please login or register to see this image.

/emoticons/default_biggrin.png" alt=":D" srcset="https://forum.fibaro.com/uploads/emoticons/[email protected] 2x" width="20" height="20" />

[T.Konopka 8]

After almost 2 years running Home Center 2 and a vast number of firmware releases, the device IDs have been sequentially increasing with every new inclusion of devices. In my setup, actual number of z-wave devices is around 40-50 (didn't actually count) but the device IDs now runs at 77x, largely due to many many inclusion and exclusion and re-inclusion of devices.

 

Is there anyway to clean up the unused device IDs and reclaim them for use?

Does the sequential device IDs, even unused ones, increase the database size or table size? If so, what is the performance impact?

 

While HC2 is significantly more powerful and the impact may not be significant, how about the same set of questions/assessments on HCL?

 

 

 

In my humble opinion, it may not be causing harm or hurt now but it is always good to be proactive and start thinking of a game plan for database housekeeping and optimisation - something typical programmers/developers are poor at or overlook while operational folks are familiar with.

 

Hello,

 

There is no such tool to do reclaim the unused IDs. Only recover without backup would do the thing, but I assume that you do not want to do that. I can assure you that the fact that IDs seem to be scrambled it does not affect the devices, scenes, etc. Moreover, it does not affect the performance of the gateway.

[Sankotronic 2,370]

Still question remains why HC occasionally deletes devices, unfortunately those which actually work perfectly and are not dead?

[chaicka 195]

Hello,

 

There is no such tool to do reclaim the unused IDs. Only recover without backup would do the thing, but I assume that you do not want to do that. I can assure you that the fact that IDs seem to be scrambled it does not affect the devices, scenes, etc. Moreover, it does not affect the performance of the gateway.

 

Yes, I understand there is no such tool at the moment. What I am pointing out is exactly that - no tool too housekeep the system and optimise the database or whatsoever to improve system stability and performance.

 

Does Home Center has some form of a SQL database in the system?

 

If so, any experienced DBA will know that over time, the database will become not optimal, sluggish, abnormal behaviour, etc and housekeep is required.

 

Here is an example of some other product which has recently added a simple mechanism/ability to do some housekeep of the system as it has been found that over long period of running, there are bound to be build up of logs and database (whitespace or whatever terminology is called) is not optimal.

 

Please login or register to see this attachment.

 

Just some suggestion to Fibaro. Whether Fibaro wants to listen or not, it is not a choice I have right. 

Please login or register to see this image.

/emoticons/default_icon_rolleyes.gif" alt=":roll:" />

[T.Konopka 8]

Yes, I understand there is no such tool at the moment. What I am pointing out is exactly that - no tool too housekeep the system and optimise the database or whatsoever to improve system stability and performance.

 

Does Home Center has some form of a SQL database in the system?

 

If so, any experienced DBA will know that over time, the database will become not optimal, sluggish, abnormal behaviour, etc and housekeep is required.

 

Here is an example of some other product which has recently added a simple mechanism/ability to do some housekeep of the system as it has been found that over long period of running, there are bound to be build up of logs and database (whitespace or whatever terminology is called) is not optimal.

 

Please login or register to see this image.

/public/style_images/master/attachicon.gif" alt="attachicon.gif">

Please login or register to see this link.

 

Just some suggestion to Fibaro. Whether Fibaro wants to listen or not, it is not a choice I have right. 

 

Hello,

 

Thank you for the suggestion. I'll make sure that someone from the software team will take a look at it.