6 ms·
As any DBA worth their salt knows. Index the many valued column, not the column with few discrete values.
by phs318u 6mo ago
As any DBA worth their salt knows.
Index the many valued column, not the column with few discrete values.
- vanviegen 6mo agoAre you sure that's a good strategy if every unique index value requires you to buy a physical container?
- vidarh 6mo agoRadix sort. Decide how many containers you're fine with, and group accordingly.
- Dylan16807 6mo agoYou can put a few shapes into one container and it's still much faster than searching color-first.
- fxtentacle 6mo agoHow about arithmetic coding? That will give you the highest amount of entropy reduction for any possible number of containers. Which probably means that you’ll sort similar pieces far apart but group by colors that are easy to separate, like red+yellow, brown+green
- layer8 6mo agoYou would use arrays: http://brickarchitect.com/wp-content/uploads/2017/03/IMG_6397-600x400.jpg http://brickarchitect.com/wp-content/uploads/2017/03/IMG_639...