Thunderstone Support Forums

I would like to be able to index the Url field of the html table to do like searches on paths. Right now I have a metamorph index on the field but the performance is slow.

The table size is about 250k rows. Return sets can be in the thousands but are usually under 500. We have 1 GB RAM on Solaris 2.9, 440 mhz CPU.

An example of a typical query is:

SELECT Url FROM html WHERE Url LIKE 'www.foo.com/health/*/women'

Is there anything I can do to make this query run faster?


Joel

<repeated>

Queries like that would be better served with matches than like.
Url matches 'www.foo.com/health/%/women'
or set matchmode=1 to allow use of * instead of %.

A metamorph index would be good if the searches were more like
Url like 'foo.com health women'