mherger wrote:
> > May I ask how "popular term" is defined? Is it generated by the
> > Full-text search's database, is it because of the search string's
> > length...?
>
> It's terms which would return more than 500 items. Track numbers or
> years can easily be part of them. But 99? I'd be surprised.
>
> FWIW: I do have 99 Luftballons in my collection. And I'm seeing the same
>
> behaviour, too.
>
> --
>
> Michael
I did some testing with debug level logging enabled.
- This time I only got one result for "99" in the first searches.
- There are three searches logged for each "1999" and "2000" while I
only searched once.
- (Same with "123", there was only one search while two were logged.)
(I had to cut that to post this here)
- (There was one search for "122" and only one logged. That's what I
would expect.) (I had to cut that to post this here)
- The last search for "99" gave me plenty results.
Why do some searches get a "w10"?
Code:
--------------------
[18-02-21 17:46:16.9290]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:99*'
[18-02-21 17:46:16.9294]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:46:16.9307]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:99*' ORDER BY fulltextweight
[18-02-21 17:46:17.0261]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:46:38.7255]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:99*'
[18-02-21 17:46:38.7260]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:46:38.7273]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:99*' ORDER BY fulltextweight
[18-02-21 17:46:38.8554]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:46:56.4073]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (251) Searching for very
popular term - limiting to highest weighted column to prevent huge result list:
'w10:98*'
[18-02-21 17:46:56.4569]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:98*'
[18-02-21 17:46:56.4573]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:46:56.4587]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:98*' ORDER BY fulltextweight
[18-02-21 17:46:56.8271]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:47:24.5352]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (251) Searching for very
popular term - limiting to highest weighted column to prevent huge result list:
'w10:97*'
[18-02-21 17:47:24.5523]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:97*'
[18-02-21 17:47:24.5528]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:47:24.5541]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:97*' ORDER BY fulltextweight
[18-02-21 17:47:24.8855]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:48:00.0133]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): '2000'
[18-02-21 17:48:00.0138]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? yes
[18-02-21 17:48:00.0161]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track 2000' LIMIT 500
[18-02-21 17:48:00.6963]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:48:01.1529]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): '2000'
[18-02-21 17:48:01.1533]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? yes
[18-02-21 17:48:01.1546]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track 2000' LIMIT 500
[18-02-21 17:48:01.4384]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:48:01.7764]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): '2000'
[18-02-21 17:48:01.7768]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? yes
[18-02-21 17:48:01.7781]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track 2000' LIMIT 500
[18-02-21 17:48:02.0843]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:48:37.7412]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): '1999'
[18-02-21 17:48:37.7417]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? yes
[18-02-21 17:48:37.7430]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track 1999' LIMIT 500
[18-02-21 17:48:38.2301]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:48:38.7059]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): '1999'
[18-02-21 17:48:38.7063]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? yes
[18-02-21 17:48:38.7076]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track 1999' LIMIT 500
[18-02-21 17:48:39.0490]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:48:39.3149]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): '1999'
[18-02-21 17:48:39.3153]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? yes
[18-02-21 17:48:39.3167]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track 1999' LIMIT 500
[18-02-21 17:48:39.6789]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:52:36.4320]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:99*'
[18-02-21 17:52:36.4325]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:52:36.4339]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:99*' ORDER BY fulltextweight
[18-02-21 17:52:36.5627]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:54:14.4884]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (251) Searching for very
popular term - limiting to highest weighted column to prevent huge result list:
'w10:91*'
[18-02-21 17:54:14.5371]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:91*'
[18-02-21 17:54:14.5375]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:54:14.5390]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:91*' ORDER BY fulltextweight
[18-02-21 17:54:14.8251]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
[18-02-21 17:54:52.7395]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (300) Search token
(track): 'w10:99*'
[18-02-21 17:54:52.7400]
Slim::Plugin::FullTextSearch::Plugin::parseSearchTerm (301) Large resultset? no
[18-02-21 17:54:52.7413]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (200) Fulltext search
query (track): CREATE TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track w10:99*' ORDER BY fulltextweight
[18-02-21 17:54:52.8365]
Slim::Plugin::FullTextSearch::Plugin::dropHelperTable (207)
--------------------
QLMS [email protected] (digimaster) / QNAP 469L QTS 4.3.4
------------------------------------------------------------------------
dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663
View this thread: http://forums.slimdevices.com/showthread.php?t=108735
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
