foo.json 10x slower than foo.json?select+*+from+foo?

[nattaylor]

Is is normal for the default json response to be >10x slow than a select *? Is the default view doing other stuff? (Maybe facets and pagination?)

ntaylor@ntaylor-mac ~ % curl -s 'https://data.nattaylor.com/d/records/records.json' | jq '.query_ms'
820.8703994750977
ntaylor@ntaylor-mac ~ % curl -s 'https://data.nattaylor.com/d/records.json?sql=select+*+from+records' | jq '.query_ms'
31.55994415283203