Please run these queries!

[Kier]

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.

 

[Paul B]

COUNT(search_id)
327

search_order total
date 327

COUNT(search_id)
0

From my live site.

 

[Kier]

Thanks, Paul.

 

[Dodgeboard]

COUNT(search_id)
781

search_order total
date 782

COUNT(search_id)
0

From my live site as well.

 

[Bob]

COUNT(search_id)
737

search_order total
date 737

COUNT(search_id)
0

Live Site ...

 

[Kier]

Dodge, bob, thank you.

 

[estranged]

COUNT(search_id)
861

search_order total
date 861

COUNT(search_id)
0

 

[dieketzer]

1. 2589
2. 2589
3. 0

it does say a lot.

 

[Kier]

it does say a lot.

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

 

[Dean]

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

search_order total
date 1062

COUNT(search_id)
0

 

[Kier]

Thanks Dean, dieketzer and estranged.

 

[bambua]

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.​

 

[yavuz]

COUNT(search_id) 7842

search_order total
date 7845

COUNT(search_id)
0

 

[Rigel Kentaurus]

From http://fanficslandia.com

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]

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.

 

[Rigel Kentaurus]

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.

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

 

[Walter]

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

 

[D.O.A.]

COUNT(search_id) 1744

date 1745

COUNT(search_id) 0

 

[dieketzer]

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

 

[Floris]

xenfans.com:

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>