There have been multiple accounts created with the sole purpose of posting advertisement posts or replies containing unsolicited advertising.
Accounts which solely post advertisements, or persistently post them may be terminated.
Vlyn , 2 days ago If you only join on indexed columns and filter it down to a reasonable number of results it’s easily fast enough. For true hierarchical structures there’s tricks. Like using an extra Path table, which consists of AncestorId, DescendentId and NumLevel. If you have this structure: A -> B -> C Then you have: A, A, 0 A, B, 1 A, C, 2 B, B, 0 B, C, 1 C, C, 0 That way you can easily find out all children below a node without any joins in simple queries.
If you only join on indexed columns and filter it down to a reasonable number of results it’s easily fast enough.
For true hierarchical structures there’s tricks. Like using an extra Path table, which consists of AncestorId, DescendentId and NumLevel.
If you have this structure:
A -> B -> C
Then you have:
A, A, 0
A, B, 1
A, C, 2
B, B, 0
B, C, 1
C, C, 0
That way you can easily find out all children below a node without any joins in simple queries.