I am setting up a POC which would create a junction between
Lookup relationships only). We would have 10k+ users each touching several records per hour, so we might expect this table to be touched upwards of 1000 times per minute. We might purge records periodically; I could see cumulative table size topping 1 million records. SOQL should still perform just fine, as we would always filter on the two lookup fields and nothing else. However, architectural review has raised the number of write operations to this table as a potential cause for concern. Is this sort of volume problematic? What type of issues specifically do I need to worry about?
I have received a bit more detail about what specifically our architect is concerned about. Apparently, Customer-Centric Engineering may throttle our attempts to save records if our volume of DML Operations against a specific table is too high. Is it known at least within an order of magnitude how many transactions would typically cross this threshold?