Re:Marriott CEO shares post-mortem on last year's hack
by bradjohnson on Tuesday March 12, 2019 @02:24PM
(#19371344)
Doesn't make sense to query the db for a count of the number of records that are returned. You can figure that out from the result set inside your application.
[ Parent
| on HN ]
Re:Marriott CEO shares post-mortem on last year's hack
by ceejayoz on Tuesday March 12, 2019 @02:27PM
(#19371375)
If the result set is "all users", you probably don't want to pull tens or hundreds of millions of records just to count them up if you're showing 100 per page.
Re:Marriott CEO shares post-mortem on last year's hack
by bradjohnson on Tuesday March 12, 2019 @02:42PM
(#19371556)
I think that something like a query for hundreds of millions of records that also required pagination for the exact number of records returned is anomalous and not something that their application would do.