default and user-defined indexes

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

default and user-defined indexes

Post by Thunderstone »



When a user creates and index like "Title\Meta" or uses the
existing "Title\Meta\Body", does the backslash basically stand
for a concatination of the fields specified on generation?

That is, would a "Title\Meta" index would look at information similar
to this?
"Our Description of META tags
meta information can store information about documents or used to generate
actions
meta,keywords,description,http-equiv,meta-data"

Thank you


User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

default and user-defined indexes

Post by Thunderstone »




Yes, These are called "virtual fields" and they are used to both
create indexes as well as search using a "LIKEx" clause.

Their value is in being able to provide accurate ranking without
having to do a SQL 'OR' on all the enumerated fields individually.

If you wish to add or change Webinator's index strategy be careful
to ensure that you always create an index with the same
fields and in the same order as they are specified in the LIKE clause.
You must update your index after significant change to the database
as well. If you don't, your search speed will be reduced.




Post Reply