1. REGISTRATION REQUIREMENTS:

    Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Not Planned Forum Home Node List Random

Discussion in 'Showcase Closed Suggestions' started by woei, Mar 15, 2014.

  1. woei

    woei Member Showcase

    Hi,

    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?

    I hope this can be easily implemented :)
     
  2. Bob

    Bob Developer Staff Member

    Random puts a HUGE load on your system when you have a lot of items which is why I tend to stay away from adding any "random" type listings in core.
     
  3. woei

    woei Member 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:

    http://jan.kneschke.de/projects/mysql/order-by-rand/

    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 :)
     
  4. Bob

    Bob Developer Staff Member

    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.
     
  5. woei

    woei Member Showcase

    Ok, thanks for explaining :)
     
  6. DeviateDefiant

    DeviateDefiant Member SC Premium

    Just speaking up saying I'd too find this feature very interesting if you can find a way to implement it without causing excessive load.
     
  7. Bob

    Bob Developer Staff Member

    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.
     
  1. 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.