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

Please run these queries!

Kier

XenForo Developer
Staff member
#1
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.
 

bambua

Well-known member
#12
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.
 

Rigel Kentaurus

Well-known member
#14
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 | 
+------------------+
 

FreshFroot

Well-known member
#15
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
 

Walter

Well-known member
#17
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
 
F

Floris

Guest
#20
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>