linear search problem on indexed field

Post Reply
jason.elder
Posts: 15
Joined: Wed May 16, 2007 11:53 am

linear search problem on indexed field

Post by jason.elder »

Hi, we're using Webinator, and through the dowalk admin have set Meta in the Index fields section...which should index Meta,
but if I run this on the command line:

texis -d <path/to/db> -s "SELECT Meta from html where Meta LIKE 'Grants'" > out

I get:
115 Query 'Grants' would require linear search

the meta field for one record has

Category: Grants
Cost: 1.55
Alphabet: A
Suitability: Technical, Public
ThumbImage: thumb_edinburgh01.jpg
ISBN: 1234
Language: English
LargeImage: grants-content-image-campbeltown.jpg
Author: George Bowie
CreationDate: 2003-09-11 14:57:53
...

so it should find something, and it should be indexed.
Do I need to reindex?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

linear search problem on indexed field

Post by mark »

The default indexing in Webinator is for the combination of fields selected in the "Index fields" option. Set that as desired and perform searches on the specified set of fields. Otherwise you'd have to create a separate index on just the Meta field to a like on just the Meta field. See creating a metamorph inverted index in the Texis manual.
jason.elder
Posts: 15
Joined: Wed May 16, 2007 11:53 am

linear search problem on indexed field

Post by jason.elder »

Thank you once again for the speedy reply.

So its fine to have the combined index through the admin and a separate one, both involving the Meta field?
jason.elder
Posts: 15
Joined: Wed May 16, 2007 11:53 am

linear search problem on indexed field

Post by jason.elder »

It works!

Thanks again
Post Reply