Re: [Ann] CintaNotes 2.0.2 Beta 1
Posted: Mon Jan 14, 2013 12:33 pm
CintaNotes Developer wrote:It's essentially the same problem.Thomas wrote:The problem is with the Link-field, not the Tag-field!
It's the difference between:
SELECT * FROM Notes WHERE text MATCH "engine google" OR link MATCH "engine google"
and
SELECT * FROM Notes WHERE (text MATCH "engine" OR link MATCH "engine") AND (text MATCH "google" OR link MATCH "google").
It is obvious that the second query will be much slower than the first.
If i want speed over hits, i can select title+text. If i go for "Anywhere" i want maximum hits. The help says, "In the Anywhere-mode, (...), CintaNotes includes all fields into the search." My expectation as a user is, that in this case search rules will always behave identical. That is a search for "word1 word2" should give my all notes containing both words "anywhere" in the text, regardless of title, text or link!
As for speed - how about the following suggestion: When storing the note in the database, append the link to the notes text using an internal syntax to separate the both. Now the search query can be executed the best way in terms of hits and speed. When reading the note for editing or displaying, the link values must be ripped from the notes text. The appended link value is redundant for search only. The use and storage of the link field itself is not affected.
Thomas