Aces High Bulletin Board

Help and Support Forums => Help and Training => Topic started by: nrshida on December 20, 2012, 10:26:12 AM

Title: Search
Post by: nrshida on December 20, 2012, 10:26:12 AM
Why does our search function only tend to find things from 2000 / 2001?  :old:
Title: Re: Search
Post by: MrRiplEy[H] on December 20, 2012, 10:35:45 AM
Why does our search function only tend to find things from 2000 / 2001?  :old:

First signs of dementia often is to lose near memory. Perhaps you remember to search only things that have happened that long ago :D
Title: Re: Search
Post by: Randy1 on December 20, 2012, 10:37:08 AM
I thought is just me doing something wrong when the early years would come up first.  

Although the search function seems to be same as other forms, I don't get very good results using this search engine.  I usually do better using google and adding Aces High as part of the search.
Title: Re: Search
Post by: nrshida on December 20, 2012, 10:42:48 AM
First signs of dementia often is to lose near memory. Perhaps you remember to search only things that have happened that long ago :D

Try it! I did find something from 2004 and nearly fell off my seat  :old:
Title: Re: Search
Post by: shiv on December 20, 2012, 10:44:26 AM
Go to Advanced Search (leave box blank and click "Search"). Then change "Message Age" to between 0 and 365 days for last year only.

Voila.
Title: Re: Search
Post by: The Fugitive on December 20, 2012, 10:48:08 AM
Go to Advanced Search (leave box blank and click "Search"). Then change "Message Age" to between 0 and 365 days for last year only.

Voila.


the searches are also much quicker this as it doesn't have to search so far back in time.
Title: Re: Search
Post by: nrshida on December 20, 2012, 11:16:40 AM
Ah thank you very much!  :salute
Title: Re: Search
Post by: Skuzzy on December 20, 2012, 11:33:58 AM
The search function times out before it can complete the search of the entire bulletin board database.  Nothing we can do about it.

One day, I'll have to dig in the code and change the default of 9999 to something more reasonable.
Title: Re: Search
Post by: nrshida on December 21, 2012, 02:04:51 AM
Can't you make the search run backwards from most to least recent Skuzzy?

Title: Re: Search
Post by: Skuzzy on December 21, 2012, 08:17:07 AM
The physical nature of a database query is to start at the beginning of the database.  Starting at the end and reading it backwards is very, very inefficient and does not solve the problem.  It would still timeout and not give back accurate results.
Title: Re: Search
Post by: nrshida on December 21, 2012, 10:45:02 AM
I thought the nature of a database was precisely to avoid sequential searching  :headscratch:

Title: Re: Search
Post by: TequilaChaser on December 21, 2012, 02:19:22 PM
Most people on these boards using search never "enlarge" or click the + sign beside the "Choose a board to search in, or search all"

if when clicking on search, it would automatically show all sub-forums and none of them be already "automatically checked" to search all forums as it is currently....

right now when someone goes to search something, it is searching for the last 9,999 days and it is searching every single forum that specific person has access to all public and all private forums....

taking that first search page out and having it to open up to show all forums, would make one decide what location(forum) their wanting to find a post in.....

my thoughts anyways, hope I posted this in a way that is understandable...

TC
Title: Re: Search
Post by: Skuzzy on December 22, 2012, 06:12:07 AM
I thought the nature of a database was precisely to avoid sequential searching  :headscratch:

When you search for a word, the entire database is selected based on the date range, then it is read.  The very nature of opening a file on a computer to start reading it will always start from the beginning and read to the end.

Bullletin boards are not indexed based on every word in every post.  It would make the index prohibitively large and extremely slow to add new records.
Title: Re: Search
Post by: nrshida on December 23, 2012, 04:42:15 PM
Couldn't you restrict the search to titles only? That would still be useful and reduce the search data enormously?