[Therion] Database use

[Andrew Atkinson]

Hello

Well Bruce you spurred me into action, and I have produced some web 
pages, that allow users to search the database.

It can be a little slow, especially the passage height query. Even the 
form is slow to load, and no indication is given that it is working. 
Finding the heights are quite quick it is the checking to see if they 
are underground that take the time, oh well probably can be optimised, 
but someone better than me.

It is set up so that more searches can be easily added.

Known problems

Passage height gives meaningless results if one or both of the heights 
given are between the min and max.
AJAX menu does not work on all browsers.

Which brings me back to the where this all started, it would be more 
user-friendly to do searches on passage names as people call them. IE 
how long is 'Route 66' Currently to do this they would have to know that 
'Route 66' was made up of the second half of Diesel Duck plus Onion and 
the first half of 'hall of time'. The first and last of these is not 
searchable?

Have a look at

http://wotcc.org.uk/Cheddar/

(the style is stolen from ubss.org.uk)

If people think that it is useful, I'll add the code to the wiki, you 
should be able to edit the config file and it should then drop in to any 
site. Extra Searches can be added to the Searches Directory, so it 
should be adaptable.

Works with mySQL.

Andrew