[OPEN-ILS-GENERAL] Request more info on: scratchpad:random_magic_spells [Evergreen DokuWiki]

[Galen Charlton]

Hi,

On Apr 14, 2011, at 3:16 PM, Kevin Kierans wrote:

> Could someone let me know what the first three reports would produce and how you would use them?
> 
> http://open-ils.org/dokuwiki/doku.php?do=show&id=scratchpad%3Arandom_magic_spells#statistics
> 
> Worst query of the day:  the query that took the most time to find the answer(s) to?

Yes.  But note that this is referring to SQL queries, not bibliographic search queries, so the purpose of this spell is to (a) identify reports that might need to be tuned and (b) identify queries generated by Evergreen application code that could be improved or benefit from additional indexes or the like.

> Counts for normalized query strings: would this tell you what people are searching for in your catalogue?  (popular searches)

Yes.

> Monthly counts:  how many searches by month?  Overall, or by org unit?

Overall.

> Would these work with a bit of tweaking in a consortium?  Results by org unit?

You could tweak it to report or filter by org unit by looking for the "org_unit" and "depth" parameters.

> Has anyone done a “no hits” report?  Queries that didn’t find anything.  (Do you need to buy something, re-catalog something, tweak the spell checker, etc.?)

Here's a grep statement to get you started:

grep 'search returned 0 results' osrfsys.*.log |grep open-ils.search |more

Regards,

Galen
--
Galen Charlton
VP, Data Services
Equinox Software, Inc. / Your Library's Guide to Open Source
email:  gmc at esilibrary.com
direct: +1 352-215-7548
skype:  gmcharlt
web:    http://www.esilibrary.com/