How not to structure database-backed web apps: performance bugs in the wild

Re:How not to structure database-backed web apps: performanc... by ht85 on Thursday June 28, 2018 @03:23PM (#17419730)

It is actually not that bad if instead of a single query, you do one query per table.

It even offsets some of the burden to the app, which is generally easier to scale than the database.

The idea is that you query the "root" table, loop over the results and build an array of IDs, then do additional queries to the other tables with a "where whatever_id IN (...)".

[ Parent | on HN ]

Re:How not to structure database-backed web apps: performanc... by Terr_ on Thursday June 28, 2018 @05:10PM (#17420508)

My understanding is that a lot of SQL drivers support compressing the data anyway, so that the server (and client) avoid duplicating the data over and over just to fill the rectangular result.

[ Parent | on HN ]