lol. lmao, even.
I imagine getting that ratio up is important, especially with recent inflation.
Oof, I felt that cut in my bones and I was only a customer.
SF doesn’t have tables. It is not a relational database. It is slow because it is an enterprise application.
The link details the steps that are triggered every time a record is updated.
https://www.salesforceben.com/learn-salesforce-order-of-exec...
A crucial aspect of the relational database is that the tables have columns which refer to another table (e.g. AccountId) and this what they call “lookup relationships” or “master-detail relationships” in Salesforce.
Also, I recently learned that SQL has triggers too in case you want the same procedure to take place after an INSERT, UPDATE, etc.
JOINS do not exist in Salesforce. Instead you have to create bridge tables. Even then you can only traverse a max of three objects at a time.
Please do not try to use Salesforce as a general database, you are only putting yourself in a world of hurt.
I'm surprised there hasn't been a Salesforce AR/VR.
The products are clunky, difficult to integrate/use/deploy, a lot of times they simply don't work or require an immense amount of effort to be barely workable. It's really hard to understand the value proposition, I guess they might have very good salespeople reaching out to the right clueless people to pitch.
This is how they operate. Just one marketing hype moment after another. The actual product doesn't really matter (and in a lot of cases doesn't even launch). They just need to keep making pretty slide decks filled with meaningless buzzwords so their customers get distracted from the fact that they are paying $500+ per user per month for a shitty web UI on top of 4 database tables.