It Searches!

We're doing it wrong...we know

It Searches!

Postby trilobyte » Sun Sep 18, 2011 7:17 am

Hooray, we survived! Thank you to those who were using the site last night, and had to deal with some very sluggish behavior. We've completed some important behind-the-scenes maintenance on ePlaya search.

Not only do we now have a fully indexed search engine (something I don't think we've had in a while), but it's an improved engine that should give faster and better results, plus allow you to do phrase matching. Search for a phrase, such as "I like cheese" (in quotes), and the search engine will return a list of messages that contain that phrase.

693,421 posts indexed. And counting, since it can now properly keep track of new threads and posts. :)
User avatar
trilobyte
Site Admin
 
Posts: 14448
Joined: Tue Mar 02, 2004 11:54 pm
Location: San Francisco
Burning Since: 2004
Camp Name: Eridu Society

Re: It Searches!

Postby Elderberry » Sun Sep 18, 2011 7:28 am

Wonderful. We've needed this for a long time.

How often will the board be reindex to include new posts? Will this be done automatically?

Thanks.
JK
Image
http://www.mudskippercafe.com
When I was a kid I used to pray every night for a new bicycle.
Then I realised that the Lord doesn't work that way so I stole one and asked Him to forgive me.
User avatar
Elderberry
Moderator
 
Posts: 13507
Joined: Tue Jul 17, 2007 10:00 pm
Location: Palm Springs
Burning Since: 2007
Camp Name: Mudskipper Cafe

Re: It Searches!

Postby ygmir » Sun Sep 18, 2011 7:35 am

Trilobyte:

Image
YGMIR

Unabashed Nordic
Pagan
User avatar
ygmir
 
Posts: 28115
Joined: Thu Sep 20, 2007 8:36 pm
Location: nevada county
Burning Since: 2017
Camp Name: qqqq

Re: It Searches!

Postby theCryptofishist » Sun Sep 18, 2011 8:19 am

Looks like Ygmir is the champion cheese-liker on this board, with a full 6 of the 18 posts of cheese-liking.
The Lady with a Lamprey

"The powerful are exploiting people, art and ideas, and this leads to us plebes debating how to best ration ice.
Man, no wonder they always win....." Lonesomebri
User avatar
theCryptofishist
 
Posts: 40267
Joined: Mon Feb 23, 2004 10:28 am
Location: In Exile
Burning Since: 2017

Re: It Searches!

Postby ygmir » Sun Sep 18, 2011 8:33 am

theCryptofishist wrote:Looks like Ygmir is the champion cheese-liker on this board, with a full 6 of the 18 posts of cheese-liking.

*standing tall and proud*
YGMIR

Unabashed Nordic
Pagan
User avatar
ygmir
 
Posts: 28115
Joined: Thu Sep 20, 2007 8:36 pm
Location: nevada county
Burning Since: 2017
Camp Name: qqqq

Re: It Searches!

Postby trilobyte » Sun Sep 18, 2011 11:14 am

The old backend was supposed to have done periodic re-indexing on its own, but from what I can gather that process got stuck at some point (or may have gotten stuck on a regular basis), which contributed to search not being very effective in the past.

The new search backend uses a SQL database, and so doesn't have the same need for periodic re-indexing that the old system did. It tracks and indexes posts and threads as they're made. From the research I did before making the change, it seems that it's a much more reliable piece of technology. But I have the ability to check on it remotely, and can periodically check the system to make sure it's working properly, and even give it a kick (force it to re-index) if I need to.
User avatar
trilobyte
Site Admin
 
Posts: 14448
Joined: Tue Mar 02, 2004 11:54 pm
Location: San Francisco
Burning Since: 2004
Camp Name: Eridu Society

Re: It Searches!

Postby Elderberry » Sun Sep 18, 2011 11:19 am

SQL? As in MSSQL? Or did you mean mySQL, as in open source?
JK
Image
http://www.mudskippercafe.com
When I was a kid I used to pray every night for a new bicycle.
Then I realised that the Lord doesn't work that way so I stole one and asked Him to forgive me.
User avatar
Elderberry
Moderator
 
Posts: 13507
Joined: Tue Jul 17, 2007 10:00 pm
Location: Palm Springs
Burning Since: 2007
Camp Name: Mudskipper Cafe

Re: It Searches!

Postby trilobyte » Sun Sep 18, 2011 11:36 am

It's MySQL (open source).
User avatar
trilobyte
Site Admin
 
Posts: 14448
Joined: Tue Mar 02, 2004 11:54 pm
Location: San Francisco
Burning Since: 2004
Camp Name: Eridu Society


Return to ePlaya Feedback

Who is online

Users browsing this forum: No registered users and 0 guests