Best result incase of search across virtual column

[Texis User]

I have created a Metamorph inverted index on virtual column a/b/c

When I run a select across this column i.e.

select * from tbl where a/b/c like $query.

it returns me irrelvant result and don't get the best search result.

So I tried to use likein. It throws error saying " needs linear search"
|||rly for the likep case I get the same error.

Any suggestions?

[Texis User]

another q:

- If I have a some columns in this virtual column that words say umbrella and I enter a query umb then it gives me No Results found.

- I have created a blob that might have say firstname and lastname seperated by space.
Now if I search on first last it doesnot show me this record.
But if I search on firstname lastname I see this record.
Pls suggest

[mark]

That should be a\b\c not a/b/c.
And you need to use likep instead of like for ranking.
Use wildcard to do prefix search: umb* first*last

[Texis User]

Hi,
That was written in hurry.

Your reply to my second q means that
I should get the query and split it
Append asteriks to it and add to the query.

OR
Use REX

Either case wouldn't this be too much processing overhead.
I have enabled number of sets of query to 100.
Worse case senario if the user enters a big query, this would slow down the display.

[John]

Yes, the system is designed to efficiently search for entire words. To search for substrings takes more processing, and requires the addition of the asterisk, which should only be applied by the user to the terms they are unsure of.

[Texis User]

no u didn't get me I meant the process of breaking the query and appending * to each word in that might cause overhead.
So wanted to know if there was any alternative to this.

As per ur first comment I used likep in my query,

<SQL ROW SKIP=$skip MAX=100
$sqlquery " first_name\last_name\email likep $txtpplsrch " $endquery>
<if $indexcount neq 0>
<has_records>
</if>
</SQL>

I c these errors in my vortex.log

006 2006-07-24 03:21:51 /webinator/Script1:207: (709) Stdout error via web server : Connection reset/closed?; exiting

Any clue?

Thanks

[John]

The time to add the asterisk to the query will be minimal compared to the time taken to get and rank all the additional matches.

The Connection reset/closed? message is most likely the user pressed Stop in the browser, or went to another page without waiting for the page to complete.

[Texis User]

No I am testing here and whenever I enter a query, it throws above error.

[Texis User]

It was data issue.

THanks