3 ms·
What dangers lay in select *...? Too much data?
by ipaddr 5y ago
What dangers lay in select *...? Too much data?
- wiredfool 5y agoMinimal if you refer to columns by name. Risky if you rely on column ordering. Can be too much data and a performance issue if you have large columns that you’re not using. (Though, it’s not much different if you’re using an orm that loads the whole object anyway), like Django or sqlalchemy. I’ve done it for many years (using named columns/ dictionaries as the result set) and its never been an issue.