/ Register

  1. REGISTRATION REQUIREMENTS:

    Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to 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 [XF1] Forum Home Node List Random

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

  1. 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. Mar 29, 2014 #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. Mar 29, 2014 #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. Mar 29, 2014 #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. Mar 30, 2014 #5
    woei

    woei Member Showcase

    Ok, thanks for explaining :)
     
  6. Apr 10, 2014 #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. Apr 10, 2014 #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.
    Accept Learn More...