A delivery quote here is not a table lookup with four zones. It is a rate for one of thousands of subdistricts, and the customer wants it before they commit.
Geography turns a shipping calculation into the most expensive query on the site.
Indonesian shipping is quoted per subdistrict across many couriers and service levels. Those tables are indexed for the lookup a checkout makes rather than left to scan.
Rates come from courier APIs, and calling them on every cart view ties your checkout to their availability. Responses are cached and refreshed on a schedule.
Shoppers expect a delivery cost early, which means the expensive lookup happens more often than the order does.
Signed-in and checkout pages always reach the origin, and Indonesia is well served from within Asia.
Traffic is overwhelmingly on phones over mobile data, so round trips matter more than payload.
A store in a country with four postal zones caches one rate table. A store spanning an archipelago is answering a distinct question for nearly every customer.
On an Indonesian store the slowest step is usually the delivery estimate, and it happens before anybody has decided to buy.
Shipping across thousands of destinations is the workload, and it sits in front of the purchase rather than after it.
| Setting | What we do | Why |
|---|---|---|
| Rate table indexing | Indexed for the subdistrict-and-courier lookup checkout performs | Indonesian delivery is quoted per subdistrict across many couriers, so the lookup is a multi-column match against a very large table. |
| Courier API calls | Cached with scheduled refresh rather than called per cart view | Quoting live on every view makes your checkout depend on a courier's uptime and multiplies your call volume by your traffic. |
| Quote placement | Treated as a pre-purchase step, not a checkout detail | Shoppers want the delivery cost before committing, so the expensive calculation runs far more often than an order is placed. |
| Origin region | Asia rather than a distant origin behind an edge | Cached pages are local either way, but the shipping quote and the checkout always reach the origin. |
| Round trips | Reduced ahead of payload size | Traffic is overwhelmingly mobile, where an additional sequential request costs more than the bytes it carries. |
Every plan includes free migration, daily backups, SSL and 24/7 support.
Move the store to an Asia origin — migration is free, rate tables indexed.