Es query problem

an index of a product with a price field. This product may have a price of 1mi N, probably less than 20.

search criteria: more than 10w, more than 50w, etc. To search for products with a price that meets these conditions

the current practice is that when you generate a product price field index, a price category is generated for the product according to each price, which is written in AME Z. for example, the price range field of a product is productA.pricre: a code Bpenc < / price >. Then go to the partial match when searching the B interval. The field of the price range.

I don"t know if there are any other good ideas

Jul.22,2021

whether to consider using a separate record for each price of a product. The price uses the number
to search the range and then remove it. The advantage is that the definition of the scope is flexible and the subsequent expansion is convenient

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eb17de-4f82e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eb17de-4f82e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?