$indexcount is higher than actual number of results

User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

$indexcount is higher than actual number of results

Post by John »

What would probably help is creating a metamorph index on URL with word expressions that match the /... and /.../ so that it can use the index for those LIKE statements. E.g.

set addexp='>>/=[^/]+';
set addexp='>>/=[^/]+/=';
create metamorph index html_Url on html(Url);
John Turnbull
Thunderstone Software
thomas.amsler
Posts: 18
Joined: Mon Nov 19, 2007 6:17 am

$indexcount is higher than actual number of results

Post by thomas.amsler »

And where would I have to enter this?

What I also still not understand when reading http://www.thunderstone.com/site/webina ... inear.html is, the actualy query word should be found in an index of the body, url or keywords. Or do I understand something wrong there? The other parameters are just there to filter the results.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

$indexcount is higher than actual number of results

Post by mark »

/ is a bad choice of leading character as that's the REX operator in a like query and will always require a linear seach and not make use of an index. "/abc/" will actually look for "abc/" linearly using REX. To force it to allow leading slash on a term you'd have to use it in an equiv list with another term. Something that wouldn't occur would be a good idea, such as "(vxzq,/abc/)" . You'd still need the index John suggested. Add those lines at the end of the "updatemmindex" function of dowalk.

In the future, please start a new topic when changing the subject.
Post Reply