1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fixed User renaming

Discussion in 'Resolved Bug Reports' started by Shamil, Apr 12, 2011.

  1. Shamil

    Shamil Well-Known Member

    Hello,

    This may be more of a suggestion, but I'm not sure how you'd tackle this with the overhead of SQL queries, and if it should be done at all.

    When a user posts a thread, their username at the time is saved in the post/thread table, hence :

    Discussion in 'Suggestions: Bigger Features' started by vrtsolus, Jul 31, 2010.

    However, if the principle post username is changed, this is not reflected in the thread.

    I am wondering if this has an effect on SEO, or what could be done, or should be - if any at all.

    Shamil
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. Kier

    Kier XenForo Developer Staff Member

    I have an idea...
     
    Shamil and Vincent like this.
  4. Kier

    Kier XenForo Developer Staff Member

    This code does what you want... but we are concerned about performance.

    We generally don't have indexes on those user ID fields, as XenForo doesn't use them for the most part, so each of these update queries, including the on on the xf_post table, could potentially be doing a full table scan.

    I'm not sure we actually want to include this in the core code.

    [​IMG]
     
  5. Kier

    Kier XenForo Developer Staff Member

    With a few minor alternations (there is now the ability to choose to disable the denormalised update if you want to) this is now in the core, and will go out with 1.0.2.
     
    majdi, laztrix, Shamil and 1 other person like this.

Share This Page