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

Real Archiving

Discussion in 'XenForo Pre-Sales Questions' started by Jafo, Aug 11, 2010.

  1. Jafo

    Jafo Active Member

    One thing that has been a pest to me in the past is dealing with HUGE post tables with VB (and other forums). I always wished there was a built in way to move posts older than X to a different table and then present users who want to search the archive a separate search option: "Search Archive". Users browsing back to X days would be presented with a "Browse Archives" section. The option to have this archive on a separate DB would be a bonus.

    An option to make this archive table read only (closing the archived threads) so we could use compression on that table would also be a bonus.

    I just think the days of having millions of of records in one busy table need to come to an end if MySQL is going to be our only DB option.
     
  2. Kier

    Kier XenForo Developer Staff Member

    Not really such a big issue if

    a) The table being used supports row-level locking (InnoDB) rather than table level locking (MyISAM)

    b) Queries don't do full table scans
     
  3. Jafo

    Jafo Active Member

    That is true and I hope it is a hint! Curious how the searching will handled if the post table will be InnoDB. :)

    As for queries doing full table scans, one also has to consider that forum owners who install third party mods are rarely aware of what types of queries these mods use, or even have the ability to understand them.
     
  4. Kier

    Kier XenForo Developer Staff Member

    The post table is indeed InnoDB, in fact the vast majority of our tables are.
     
    gordy and Been Told like this.
  5. Jafo

    Jafo Active Member

    Awesome!

    Forgive me if I press too hard but remember I am on the outside looking in :) -> How will searching on InnoDB tables be performed?
     
  6. Kier

    Kier XenForo Developer Staff Member

    We'll have a full discussion about our search system in the future but the time is not right quite yet.
     
  7. Tigratrus

    Tigratrus Well-Known Member

    Excellent. Scalability planned from the beginning FTW :).
    Very interested to hear about the search system, how different content types will be integrated, visual presentation (tabbed results sets?) etc.
    Can't wait till it's ready to be unveiled!
     
    Been Told likes this.

Share This Page