SEARCH is not working as expected on ...

John-Simpson

Posts: 167
Registered: 15-Jan-2008

SEARCH is not working as expected on large Albums for "two words"
Posted: 18 Jan 25, 19:22

The main reason that I changed from JUPITER to TIGER was because of your wonderful SEARCH facility. However, on my extra wordy large albums, it doesn't return enough results for two-word searches in inverted commas.

For example on this album: Link: https://www.legsreunited.org.uk/index.html
putting in the word Tribbensee returns 94 results - correct.

However, entering "Kevin Tribbensee" returns only 3 results - incorrect. (I know nearly all the 94Tribbensee results have Kevin as a forename!)

I've tested the search on a small test Album and all works fine.

Test Album: Link https://john-simpson.jalbum.net/Tiger-Test/index.html

Foo and Boo and Foo Boo are returned correctly, so I am mystified as to why the search doesn't work on a large album.

Size of Album: 3857 images13 audios48 videos11 others

To completely remake took 79 minutes and upload in 17 minutes

Windows PC running Windows 10 - about 8 years old!

Edited by: John-Simpson on 18 Jan 2025, 19:05

MarkusD

Posts: 761
Registered: 13-Apr-2006

Re: SEARCH is not working as expected on large Albums for "two words"
Posted: 19 Jan 25, 18:40

in response to: John-Simpson

Reply

John-Simpson wrote:
However, entering "Kevin Tribbensee" returns only 3 results - incorrect. (I know nearly all the 94Tribbensee results have Kevin as a forename!)

I get the result „Kevin Tribbensee” 166 image(s)“. Just to let you know. This is the result using FireFox, Edge or Brave.

Cheers, Markus

JeffTucker

Posts: 8,099
Registered: 31-Jan-2006

Re: SEARCH is not working as expected on large Albums for "two words"
Posted: 19 Jan 25, 18:49

in response to: MarkusD

Helpful

Reply

I get only three, like John.

As usual, it depends on the quoting:

"Kevin Tribbensee" - 3 results
Kevin Tribbensee - 166 results

The second version is an "or" test, not an "and" test.

John-Simpson

Posts: 167
Registered: 15-Jan-2008

Re: SEARCH is not working as expected on large Albums for "two words"
Posted: 19 Jan 25, 23:32

in response to: JeffTucker

Reply

JeffTucker wrote:
I get only three, like John.

As usual, it depends on the quoting:

"Kevin Tribbensee" - 3 results
Kevin Tribbensee - 166 results

The second version is an "or" test, not an "and" test.

Quite right Jeff. The 166 results also includes all the other people named Kevin plus the 94 instances of Kevin Tribbensee. Logic says that the database is picking up the all the names because a single name search finds them but combining 2 words inside quotation marks falls short of finding each instance. (Exact phrases fail)

Laza

Posts: 1,631
Registered: 6-Sep-2005

Re: SEARCH is not working as expected on large Albums for "two words"
Posted: 20 Jan 25, 14:58

in response to: John-Simpson

Correct

Reply

I see now what the problem is. The quote marks trigger an exact search, which means the given field should be strictly "Kevin Tribbensee," not part of the comment.

I will add another check for this case so you can search within non-exact fields, like the comment. I never thought the search would be so hard to implement. It looks so easy, but translating it into machine language is a nightmare.

John-Simpson

Posts: 167
Registered: 15-Jan-2008

Re: SEARCH is not working as expected on large Albums for "two words"
Posted: 21 Jan 25, 16:14

in response to: Laza

Reply

Laza wrote:
I see now what the problem is. The quote marks trigger an exact search, which means the given field should be strictly "Kevin Tribbensee," not part of the comment.

Yes, that is the logical reason for not finding all the instances of "Kevin Tribbensee". If the comment or title contains other words as well as Kevin Tribbensee, then the search doesn't pick up the search phrase! Well done for finding the reason.

I will add another check for this case so you can search within non-exact fields, like the comment. I never thought the search would be so hard to implement. It looks so easy, but translating it into machine language is a nightmare.

What ever you do to try and fix this, I hope the single word search still works as well as it does. The single word search is by far the most important of the 3 search types. I don't think I ever needed to do a 2 word search in the same document,. (Word1 and Word 2)

Edited by: John-Simpson on 21 Jan 2025, 15:15

John-Simpson

Posts: 167
Registered: 15-Jan-2008

Re: SEARCH is not working as expected on large Albums for "two words"
Posted: 23 Jan 25, 11:46

in response to: Laza

Reply

Laza wrote:
I will add another check for this case so you can search within non-exact fields, like the comment.

I notice that you've fixed the error, and SEARCH works as expected.

Thank you for your swift action.

Best wishes John