4 ms·
> ... the OP wrote a script with a loop. Are you sure? The article doesn't say anything about a loop, and the estimated usage by the Google responder makes it
by justinclift 3y ago
> ... the OP wrote a script with a loop.
Are you sure?
The article doesn't say anything about a loop, and the estimated usage by the Google responder makes it seem like the cost is from a single "SELECT *".
- mulmen 3y agoAccording to https://news.ycombinator.com/item?id=39447465 https://news.ycombinator.com/item?id=39447465: > I was doing historical evaluation for a few sites, so I was running a query for each month going back to 2016 for each site. I've done this before with no real issues, and if I knew the charges were rapidly exploding I'd have halted the script immediately - but instead it ran for 2 hours and the first notice I got was the CC charge. So looks like a loop of ((6 * 12) + 2) * #sites iterations with a full table scan every time.
- justinclift 3y agoThanks, that does add further detail after all. :)