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

The Alert System

Discussion in 'XenForo Pre-Sales Questions' started by Roach, May 24, 2012.

  1. Roach

    Roach Active Member

    I am interested to know how the alert system pulls the data from replies to threads I have replied to.

    The reason why I want to know is because I am highly interested in Xenforo but have no idea how the alert system works and as my friend pointed out whilst trying to do an alert system for another software, the only way he could see to do it would create a lot of queries and therefore use a lot of disk space. So how do you go about doing this, does it create a lot of queries? Because I would not want it to use up all my disk space because of the alert system.
  2. Chris D

    Chris D XenForo Developer Staff Member

    Disk space will not be an issue.

    As far as I can tell, alerts automatically expire after a certain amount of time and once the alerts have been viewed they are removed from the database.
  3. euantor

    euantor Well-Known Member

    I too am interested in how it works as the only way I've ever been able to think of doing it is hardly optimal (especially the notification of replies to threads you've posted in). I can't quite tell if the alerts are instant either though as on some forums they seem delayed.
  4. Chris D

    Chris D XenForo Developer Staff Member

    They are instant. But you will only see them appear if you reload the page or an AJAX operation occurs on the page such as posting a reply or loading an overlay such as the member card.

    It depends what you'd class as hardly optimal.

    They work great on every single XenForo forum I use.
  5. euantor

    euantor Well-Known Member

    That would explain it I guess. I'm mostly just wondering about what the average query count per page is. I like to know stuff like that before thinking about choosing a piece of software so that I know how long my hosting will be able to handle the load before I need to up my resources.
  6. Slavik

    Slavik XenForo Moderator Staff Member

    It won't give you any issues.
  7. euantor

    euantor Well-Known Member

    Fair enough. I'm likely going to be buying a license within the next month or two no matter what anyway. As soon as my car passes it's MOT I'll know.
  8. Onimua

    Onimua Well-Known Member

    In general, XenForo's queries average about 10 per page, usually varying depending on cron jobs and other things but it's very light otherwise.
  9. euantor

    euantor Well-Known Member

    That's pretty darn impressive I must say. Does that include thread listings? I usually use MyBB and it averages 9 on index and close to 20 when viewing a thread.
  10. Onimua

    Onimua Well-Known Member

    Viewing a thread on my localhost on XF 1.1 currently has 11 queries performed.
  11. euantor

    euantor Well-Known Member

    That's definitely quite surprising. When I was using vB I seem to remember a similar query count to MyBB's too so I thought that was about average.
  12. Mr. Goodie2Shoes

    Mr. Goodie2Shoes Well-Known Member

    well... if you install add-ons that uses MySQL queries, then the number will definitely increase... For my site:
    index: 20 queries (took .13 seconds)
    forum view: 17 queries (took .12 seconds)
    thread view: 27 queries (took .27 seconds)
    and I have 35 add-ons installed...

Share This Page