...

BUMP.

Givin' this some love~

source: animenewsnetwork

Join SRoMU Scanlations or visit #SRoMU at IRCHighWay.

Currently, this was removed due to performance issues. I didn't realize it before, but I'm having trouble getting MySQL to search two fulltext indexes which reside in two different tables at the same time. MySQL will not use the fulltext key in this case, and each search was actually doing a full table scan. I took out the description fulltext search from the query string, and the queries immediately optimized to use the title fulltext index. I've been messing with the query for a while to figure out hot to fix it, but no luck so far.

Until I can figure that out, I'm afraid we'll have to do without description searches for now ...

I could probably make an option where you can decide to search specifically by description or title, that might work... Let me know what you think.

-M

Is there a way that you can search for multiple words that must show up together? Such as put quotes around them? Or some other way that you can narrow out those descriptions or titles which only have one but not both?

Edit: Being able to choose to search by title or description would be useful (definitely more useful than not being able to search descriptions at all).

If you've ever thought or said "Nice Guys finish last" and really meant it, then you should probably read this LJ post by DivaLion. It's incredibly insightful whether you're male or female.

From a bumper sticker I like:
"If you're gonna ride my ass, at least pull my hair."

Use "AND" and "OR"

Naruto AND dj
something OR something2

Heh, should've known. Thanks. =)

If you've ever thought or said "Nice Guys finish last" and really meant it, then you should probably read this LJ post by DivaLion. It's incredibly insightful whether you're male or female.

From a bumper sticker I like:
"If you're gonna ride my ass, at least pull my hair."

Heh, should have known indeed. Thanks for the heads up~
And yeah, searching by description solely is a handy feature.

It should be implemented if possible~

source: animenewsnetwork

Join SRoMU Scanlations or visit #SRoMU at IRCHighWay.

...

This is done.

...

A bit of an unrelated issue but I've noticed that the search doesn't come up with results when you search for numbers like "five" or "zero".

use quotes for common words

"five"

edit: also, small bug fixed, i removed the associated titles from description searches, so only the main title shows up now.

Quote from Manick

Currently, this was removed due to performance issues. I didn't realize it before, but I'm having trouble getting MySQL to search two fulltext indexes which reside in two different tables at the same time. MySQL will not use the fulltext key in this case, and each search was actually doing a full table scan. I took out the description fulltext search from the query string, and the queries immediately optimized to use the title fulltext index. I've been messing with the query for a while to figure out hot to fix it, but no luck so far.

Until I can figure that out, I'm afraid we'll have to do without description searches for now ...

I could probably make an option where you can decide to search specifically by description or title, that might work... Let me know what you think.

-M

If you still have the same problem: Maybe it works if you do the search multiple times, with only one fulltext search per search and merge the results (either with union from sql or php)?

Besides that, series seem to show up multiple times on the search results, is that possible to remove? For example if you search for "zero" in the title, you get Zero-One 3 times in a row, in cause of the associated names at least it seems so to me.

It's done that way on purpose, so that you can search based on associated titles ...

Yes. But then you only need to display one of the matches for the same series, no?
You would still find the series like that, but it wastes less space so it is easier to look over the results, especially if the same series results dont come in a row it get's a bit confusing to look over.