Currently there are options to show most recent, top rated ect options to show showcase items. But can there be a simple random option? To show random items from the showcase?
Ok, in that case I don't op for this. I thought it wasn't as though but now you say this I understand the problem when using rand. But this might be helpful for random selects from a lot of records:
But, for me performance is most important. So if it is not possible without using much resources, don't implement I have too much queries already on my homepage
using RAND in a query is VERY intensive. its not the number of queries that you need to be concerned with, its what each query is actually doing. 1 HEAVY query (like doing a RAND against 1000's of items) is worse than multi properly indexed queries.
Its not so bad when you don't have A LOT of items. I guess I could look into adding it and just add a note saying that it is a very intensive process and could slow load times down.. ie, use at your own discretion.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.