[Therion] Database use
Martin Sluka
martinsluka at mac.com
Mon Jan 10 19:10:07 CET 2011
Nice work, Andrew. Please, add the units (I know you think in feets) :)
m.
On 10.1.2011, at 17:59, Andrew Atkinson wrote:
> 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
>
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> http://mailman.speleo.sk/mailman/listinfo/therion
More information about the Therion
mailing list