It Searches!

We're doing it wrong...we know
User avatar
trilobyte
Site Admin
Posts: 15799
Joined: Tue Mar 02, 2004 10:54 pm
Burning Since: 2004
Camp Name: Eridu Society
Location: San Francisco
Contact:

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
Elderberry
Moderator
Posts: 13956
Joined: Tue Jul 17, 2007 10:00 pm
Burning Since: 2007
Camp Name: Mudskipper Cafe
Location: Palm Springs
Contact:

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
ygmir
Posts: 28567
Joined: Thu Sep 20, 2007 8:36 pm
Burning Since: 2017
Camp Name: qqqq
Location: nevada county

Re: It Searches!

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

Trilobyte:

Image
YGMIR

Unabashed Nordic
Pagan

User avatar
theCryptofishist
Posts: 40296
Joined: Mon Feb 23, 2004 9:28 am
Burning Since: 2017
Location: In Exile

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
ygmir
Posts: 28567
Joined: Thu Sep 20, 2007 8:36 pm
Burning Since: 2017
Camp Name: qqqq
Location: nevada county

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
trilobyte
Site Admin
Posts: 15799
Joined: Tue Mar 02, 2004 10:54 pm
Burning Since: 2004
Camp Name: Eridu Society
Location: San Francisco
Contact:

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
Elderberry
Moderator
Posts: 13956
Joined: Tue Jul 17, 2007 10:00 pm
Burning Since: 2007
Camp Name: Mudskipper Cafe
Location: Palm Springs
Contact:

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
trilobyte
Site Admin
Posts: 15799
Joined: Tue Mar 02, 2004 10:54 pm
Burning Since: 2004
Camp Name: Eridu Society
Location: San Francisco
Contact:

Re: It Searches!

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

It's MySQL (open source).


Return to “ePlaya Feedback”

Who is online

Users browsing this forum: No registered users and 0 guests