Re: Tjapnichnyj search of the goods in a dial-up of attributes
mayton , give we count...
The list on 10 the goods. Each goods have some characteristics (if to look on the same jandeks-market on the average at a category of their goods there 20-30, it is rare more than fifty). Besides extremely rarely the characteristic with very extensive value range comes across, personally I did not see any in which the amount of values would exceed 64 (or at least came nearer to it). But if to take on a maximum... Let 20 the goods on 50 characteristics which coding demands 64 bits, it turns out the order of hundred megabytes. Not great volume. And with the registration of that the table strictly RO - we load a table copy in storage, and here to you already a minus a disk subsystem and a gain of speed.
Some additions. Really at the goods normally no more than fifty unique characteristics.
But your assumption of that that in the whole category of the goods (TV sets, refrigerators) 50 characteristics - is incorrect.
Technologies change each 2-3 years and new characteristics are added to the new goods (SmartTv=true);
And old gradually leave (VGA =true).