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

Please run these queries!

Discussion in 'Off Topic' started by Kier, Mar 2, 2011.

  1. Kier

    Kier XenForo Developer Staff Member

    I'm doing a little investigation at present into some usage statistics, and it would help me greatly to get some more data from active boards.

    If you know what you're doing, could you please run the following queries against your own database and post back the results here?

    Thanks!

    Here are the queries:
    1. SELECT COUNT(search_id)
      FROM xf_search;

    2. SELECT search_order, COUNT(search_id) AS total
      FROM xf_search
      GROUP BY search_order;

    3. SELECT COUNT(search_id) FROM xf_search
      WHERE search_constraints LIKE '%reply_count%';
    These are simply data selections, you can't damage your XenForo installation by running them.

    Please note that I only require data from active boards, I am measuring usage patterns so data from test installations is not useful to me. Thx.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    COUNT(search_id)
    327

    search_order total
    date 327

    COUNT(search_id)
    0

    From my live site.
     
  3. Kier

    Kier XenForo Developer Staff Member

    Thanks, Paul.
     
  4. Dodgeboard

    Dodgeboard Well-Known Member

    COUNT(search_id)
    781

    search_order total
    date 782

    COUNT(search_id)
    0

    From my live site as well.
     
  5. Bob

    Bob Well-Known Member

    COUNT(search_id)
    737

    search_order total
    date 737

    COUNT(search_id)
    0

    Live Site ...
     
  6. Kier

    Kier XenForo Developer Staff Member

    Dodge, bob, thank you.
     
  7. estranged

    estranged Well-Known Member

    COUNT(search_id)
    861

    search_order total
    date 861

    COUNT(search_id)
    0
     
  8. dieketzer

    dieketzer Well-Known Member

    1. 2589
    2. 2589
    3. 0
    it does say a lot.
     
  9. Kier

    Kier XenForo Developer Staff Member

    It does. Keen to get a wider spread of data though.
     
  10. Dean

    Dean Well-Known Member

    Converted to xf about 5 weeks ago:
    COUNT(search_id)
    1062

    search_order total
    date 1062

    COUNT(search_id)
    0
     
  11. Kier

    Kier XenForo Developer Staff Member

    Thanks Dean, dieketzer and estranged.
     
  12. bambua

    bambua Well-Known Member

    COUNT(search_id)
    943

    search_ordertotal
    date943

    COUNT(search_id)
    0
    Went live with a converted VB board about a week ago. Decent amount of traffic but a pretty closed group of people.
     
  13. yavuz

    yavuz Well-Known Member

    COUNT(search_id) 7842

    search_order total
    date 7845

    COUNT(search_id)
    0
     
  14. Rigel Kentaurus

    Rigel Kentaurus Well-Known Member

    From http://fanficslandia.com

    Code:
    mysql> SELECT COUNT(search_id)
        -> FROM xf_search;
    +------------------+
    | COUNT(search_id) |
    +------------------+
    |             1419 | 
    +------------------+
    
    
    mysql> SELECT search_order, COUNT(search_id) AS total
        -> FROM xf_search
        -> GROUP BY search_order;
    +--------------+-------+
    | search_order | total |
    +--------------+-------+
    | date         |  1420 | 
    +--------------+-------+
    
    
    mysql> SELECT COUNT(search_id) FROM xf_search WHERE search_constraints LIKE '%reply_count%';
    +------------------+
    | COUNT(search_id) |
    +------------------+
    |                0 | 
    +------------------+
    
    
    
     
  15. FreshFroot

    FreshFroot Well-Known Member

    only difference I see so far is some people don't have matching search id's with search orders. While others have them exactly the same. :p
     
  16. Rigel Kentaurus

    Rigel Kentaurus Well-Known Member

    I think that we can also make a point into saying that nobody ever uses the function of sort by most replies on the search
     
  17. Walter

    Walter Well-Known Member

    Some samples from smaller forums, all show the same pattern:
    Board 1:
    1: 10
    2: date, 10
    3: 0

    Board 2:
    1: 29
    2: date, 29
    3: 0

    Board 3:
    1: 7
    2: date, 7
    3: 0
     
  18. D.O.A.

    D.O.A. Well-Known Member

     
  19. dieketzer

    dieketzer Well-Known Member

    obviously entering a search term from any page and clicking submit is just too damned easy.
     
  20. Floris

    Floris Guest

    xenfans.com:

    Code:
    mysql> use xxx;
    Database changed
    
    mysql> SELECT COUNT(search_id)
        -> FROM xf_search;
    +------------------+
    | COUNT(search_id) |
    +------------------+
    |              101 |
    +------------------+
    1 row in set (0.00 sec)
    
    mysql> SELECT search_order, COUNT(search_id) AS total
        -> FROM xf_search
        -> GROUP BY search_order;
    +--------------+-------+
    | search_order | total |
    +--------------+-------+
    | date         |   101 |
    +--------------+-------+
    1 row in set (0.00 sec)
    
    mysql> SELECT COUNT(search_id) FROM xf_search
        -> WHERE search_constraints LIKE '%reply_count%';
    +------------------+
    | COUNT(search_id) |
    +------------------+
    |                0 |
    +------------------+
    1 row in set (0.00 sec)
    
    mysql> 
     

Share This Page