How I Engineered a 1.7M Row Product Safety Database to Serve Pages in 66ms on a Single Free VM
Let me tell you what happens when you shove 1.7 million dense PostgreSQL rows onto a 6GB ARM instance and then try to serve real user traffic.
Sequential table scans that choke the server for 45 seconds. COUNT(*) queries that make the query planner weep. Multi-language LLM translation costs that compound into a budget black hole before your first hundred users hit the site.
That's where LemonKnows started — a consumer safety and food intelligence platform tracking 1.7M products, 41,000 global government recalls, and 100,000+ community complaints, all running on Oracle Cloud Free Tier with zero recurring hosting cost.
Today, user-facing pages assemble in 66ms.
Here is the exact engineering playbook that got it there.
The Problem With COUNT(*)
If you are running SELECT COUNT(*) on tables with millions of records to power front-end pagination or dashboard metrics, you are actively killing your database.
PostgreSQL handles MVCC (Multi-Version Concurrency Control)...
Copyright of this story solely belongs to hackernoon.com. To see the full text click HERE
