3 ms·
You didn't really understand what I meant, which I guess is my fault. When I say parent I don't mean in the same table, I mean an unrelated parent (1 to many j
by ars 15y ago
You didn't really understand what I meant, which I guess is my fault.
When I say parent I don't mean in the same table, I mean an unrelated parent (1 to many join).
And I use sort all the time without limit, I think it's important for data to always be displayed in a consistent order.
> And in cases where you can't fetch the data efficiently in a single query, you're probably doing it wrong
Example:
I have a list of buildings, then I have a list of room, then a list of contents.
I want to create a giant page on the website displaying this data. One table for each building, one row for each room, one cell for each content.
You can not get all this data efficiently in a single query.
You can get the data by joining all three tables, but you will be repeating the data about the building over and over for each content.
- bad_user 15y agoRight, sorry, I misunderstood you.