VGMdb
Go Back   VGMdb Forums > Discussion > Miscellaneous Discussion
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Jun 29, 2018, 06:39 AM
Aifread's Avatar
Aifread Aifread is offline
Senior Member
 
Join Date: Sep 2016
Posts: 183
Default Ignored search terms

Sorry if this has been brought up before, but I really don't see the point of ignoring certain words in searches. I don't know of any other site or search engine that overtly does this and I'd rather not have to type double quotes around everything when I wanna find something from a specific numbered Final Fantasy game, for example. I typed the full name of the game there for a reason but the site then patronizes me by saying I should've typed quotation marks. I get that it's meant to catch mistakes but honestly I think it does more harm than good.
Reply With Quote
  #2  
Old Jul 1, 2018, 06:14 AM
Rrolack Rrolack is offline
Senior Member
 
Join Date: Sep 2014
Posts: 307
Default

I agree that the search would be more user-friendly without dropping one and two character phrases.

If dropping these is still seen as important, a few suggested adds to the "exception list" are all numbers (e.g. "2", "3", ..., "99") and roman numerals (e.g. "I", "II", "IV, ...).
Reply With Quote
  #3  
Old Jul 2, 2018, 07:37 AM
dancey's Avatar
dancey dancey is offline
Trusted Editor
 
Join Date: Dec 2007
Location: New Jersey
Posts: 1,275
Default

You need to use quotes because it searches for terms individually and is a union of all search terms. Searching for:

Version Sound

is searching for anything that contains both the word 'sound' and 'version', in any order.

Searching for:

"Version Sound"

is searching for explicitly the term "Version Sound" in that order, which significantly limits results.

Allowing non-quoted < 3 character searches would create problematic queries in that searching for 'i', 'iv', 'v', 'vi' would return results where the album contained the letter 'i', 'v', the letters 'iv' (ex: Live), 'vi' (ex: Video). That's a problem both for the user (too many results) and the database (returning so many results).

Use quotes or use google to do searching (ex: final fantasy iv site:vgmdb.net)
Reply With Quote
  #4  
Old Jul 2, 2018, 08:09 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Location: 5.342.482.337.666
Posts: 3,810
Default

you can use stuff like " iv " (or " iv", "iv ")
of course if some letters are stuck, it doesn't help
Reply With Quote
  #5  
Old Jul 2, 2018, 04:12 PM
Rrolack Rrolack is offline
Senior Member
 
Join Date: Sep 2014
Posts: 307
Default

Quote:
Originally Posted by dancey View Post
Allowing non-quoted < 3 character searches would create problematic queries in that searching for 'i', 'iv', 'v', 'vi' would return results where the album contained the letter 'i', 'v', the letters 'iv' (ex: Live), 'vi' (ex: Video). That's a problem both for the user (too many results) and the database (returning so many results).
Interesting. I had no idea that the search matches partial words.

Out of curiosity, is *that* behavior considered desirable or typical of search engines? This is to say: if we want a search where "oun" returns every album containing "sound," then it's understandable that a search for 'final fantasy iv' (without quotes) can't be accepted. But is it the former behavior considered beneficial (or beneficial enough) to be worth sacrificing the latter?
Reply With Quote
  #6  
Old Jul 2, 2018, 04:26 PM
dancey's Avatar
dancey dancey is offline
Trusted Editor
 
Join Date: Dec 2007
Location: New Jersey
Posts: 1,275
Default

People far smarter than me have written entire theses on the subject of search and indices. The search could be improved but it would take a new plugin or new coding and I don't know that it's realistic. You will already get an error if your search returns too many results (Try searching for "Sound" or "Original")

Code:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 9475477 bytes) in /home/vgmdb/public_html/db/albums-search.php on line 327
Realistically it's just not worth the development time when all it takes is using quotes, imo. It's unrealistic for people to be searching for such broad terms that it presents itself as a common issue, though as the database grows larger it may require attention if common searches like "Final Fantasy" or artists with huge catalogs start bombing.
Reply With Quote
  #7  
Old Jul 2, 2018, 10:45 PM
Aifread's Avatar
Aifread Aifread is offline
Senior Member
 
Join Date: Sep 2016
Posts: 183
Default

It's already a problem with searching for "Ys," as that brings up all albums containing those letters in that order. I may not have a thesis, but matching letters rather than words like that seems generally undesirable to me. I understand that it would be a pain in the ass to change though. Was just wondering if anyone had taken it into consideration as an issue.
Reply With Quote
  #8  
Old Jul 6, 2018, 02:49 PM
Datschge's Avatar
Datschge Datschge is offline
Trusted Editor
 
Join Date: Mar 2008
Posts: 702
Default

A normal full text search most newer databases offer would be an improvement already. Full text searches work by word instead by character, and instead having to explicitly set a word as word with quotes one instead has to allow partial matches with asterisks.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Search by UPC in main search box. cheaplightning Questions and Comments 0 Jan 27, 2016 12:50 PM
Search name of some musics LeReveur Video Game Music Discussion 13 Jun 27, 2014 02:41 PM
about advanced search Phonograph Questions and Comments 6 Nov 21, 2012 07:28 AM
Updates search? Dag Questions and Comments 13 May 6, 2010 11:16 AM
A not ok search my_name_is_link Questions and Comments 4 Jun 27, 2009 04:28 PM