What kind of database architecture could cause SELECT \* to be slow? | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		olavk on June 28, 2018 \| parent \| context \| favorite \| on: How not to structure database-backed web apps: per... What kind of database architecture could cause SELECT * to be slow?

kyberias on June 28, 2018 [–]

Any. "Architecture" has nothing to do with that. SELECT COUNT(*) is usually "slow".

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact