Query Counter
save, insert, update, remove, delete, find, count, listeners and soft delete: count the SQL each one sends.
0 / 8 levels · 0 / 24 ★Start playing ›
Query Counter
The repository is a waiter and the database is the kitchen. Every SQL statement is one trip to the kitchen, and trips cost time. Some orders take one trip, some take four. Learn to count the trips before you place the order.
Your rulebook
Finish a level to add its rule. Fill the book and you can explain all of this in an interview.
- 1Finish save() of a new object to unlock this rule.
- 2Finish insert() skips the transaction to unlock this rule.
- 3Finish save() looks before it writes to unlock this rule.
- 4Finish update() goes straight in to unlock this rule.
- 5Finish Listeners need a real entity to unlock this rule.
- 6Finish Every read is a trip to unlock this rule.
- 7Finish remove() loads, delete() just deletes to unlock this rule.
- 8Finish Soft delete only hides to unlock this rule.