Re:User-defined Order in SQL
by billysielu on Wednesday March 21, 2018 @06:52AM
(#16636924)
Agree. I wonder what problem anyone would have with Approach 1 that also meant the other approaches were optimal solutions.
If your problem is there are too many items in the list, that's going to be a usability problem so you'd probably need to categorize the items.
If performance is such an issue that ordering <50 items with approach 1 is unacceptable you undoubtedly have performance issues with the rest of your app too.
Re:User-defined Order in SQL
by mastax on Wednesday March 21, 2018 @09:55AM
(#16637978)
I assume that this method was invented for storing some large ordered list - not for a literal Todo list app. Any realistically sized Todo list can be stored anywhere. Hell, you could probably use pingfs for it.
If your problem is there are too many items in the list, that's going to be a usability problem so you'd probably need to categorize the items.
If performance is such an issue that ordering <50 items with approach 1 is unacceptable you undoubtedly have performance issues with the rest of your app too.