News for hackers. Stuff that matters.

Ask HN: Resources for SQL database schema design/performance?

I have a solid understanding of the basics of relational DB performance (Indexing, explain analyze, different types of scans etc...) but I always seem to run into situations where I have complex and slow SQL queries and I'm not sure how to optimize them. I've often heard the rule of thumb that any user-facing query that takes longer than 100ms is too slow but I've never seen that play out in my experience with many complex application queries taking a handful of seconds. Does anyone have any suggestions for required reading related to performant data architecture?
( 1 comment | on HN )
Re:Ask HN: Resources for SQL database schema design/performa... by gigatexal on Saturday November 23, 2024 @03:14PM (#42223569)
I can’t answer your questions but perhaps some more context on why a 100ms query is too slow and what all you’re building. Seems really interesting