starinacool
starinacool
@sanikolaev This feature can be used to create recommendation system. The same functionality could be achieved be using 2 requests. 1. select vector from listing where id=555; 2. select id,...
@sanikolaev 555 - is a user input. Lets say a User opens a page with an item number 555. And now I want to show him a list of similar...
``` SELECT id,name FROM listing WHERE match('test') FACET ut DISTINCT salesman ORDER BY count(distinct salesman) DESC ```
Thanks for advice. Lets make it a feature request: sort by distinct count in facets.
It would be nice. I am doing this in my PHP code now: ` $max_matches=$params['start'] + $params['count']; `
@sanikolaev I found out that the problem acures when I use hitless file for index like: ` _P1 _B1 _B2 _C1 _F1 _F2 _F3 _G1 _G2 _H1 _J1 _J2 _K1...
@sanikolaev I mean: hitless_words = /var/lib/manticore/hitless.txt cat /var/lib/manticore/hitless.txt ` _P1 _B1 _B2 _C1 _F1 _F2 _F3 _G1 _G2 _H1 _J1 _J2 _K1 _L1 _M1 _M2 _A _B _C _D _E...
@tomatolog ``` CREATE TABLE listing2 ( id bigint, n text, params text, uts text, desc text, curency integer, `type` integer, num_of_bids integer, d_abrod integer, cty integer, cntry integer, d_local integer,...
@sanikolaev Yes, but the one I've shared is the one without using hitless words.
https://www.kernel.org/doc/html/latest/filesystems/proc.html#meminfo