Request for feedback on Inventory Consolidation to tackle lags

[solper]

Bit techy here... But recycling a unit doesn't hard delete the unit.. it soft deletes it so the performance issue still exists as it has to ignore it when calculating

The units who are soft deleted have a unique identyfyer in database and should be eady to delete by a agent running a simple script

[HellRaizer]

The units who are soft deleted have a unique identyfyer in database and should be eady to delete by a agent running a simple script

That is such a rookie thing to stay. The implications of a “simple delete” are rather large.

Let’s take SQL Server, which I believe they use on AWS.

This may one of the largest tables
Is it partitioned ? Probably not
Is it over indexed / under indexed?
How long does it take to delete, let’s say 1000 rows?
Will the table lock, will that cause blocking/deadlocks and therefore gamer impact
Deleting on its own will cause fragmentation and leave the table the same size. Therefore how long will an index rebuild take?

I could keep going on. Bugs me when I’m sent to review a clients DB model and process and the “developers” think that databases are “simple”