Can't rank FTN

Post Reply
mjacobson
Posts: 204
Joined: Fri Feb 08, 2002 3:35 pm

Can't rank FTN

Post by mjacobson »

Hi,

I am trying to speed up the searching against one of my vortex tables by using either a "like" or a "likep" instead of a "=" expression.

I am searching against the ID column with is type counter and I have created a metamorph inverted index on that column. When I do a search I am getting:

"100 Can't rank FTN type 19 in the function i3dbinsertp"

Here are some more details
<sql "set hyphenphrase = 0"></sql>
<sql "set addexp='[\alnum\/\+\-\._/]{1,70}'"></sql>

What am I doing wrong here?
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Can't rank FTN

Post by John »

A counter is an internal type that wasn't designed for using "LIKE" or "LIKEP" with.

Normally an '=' should be more efficient than LIKE in this case. If you want to open a support ticket we might be able to get some more details to solve the original speed problem a different way.
John Turnbull
Thunderstone Software
mjacobson
Posts: 204
Joined: Fri Feb 08, 2002 3:35 pm

Can't rank FTN

Post by mjacobson »

Thanks. I hate opening up a trouble ticket on this. Have a great day John.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Can't rank FTN

Post by mark »

No one's explicitly said it so I will just to cover the bases. Creating a regular index on the counter field will make the = lookup fast.
mjacobson
Posts: 204
Joined: Fri Feb 08, 2002 3:35 pm

Can't rank FTN

Post by mjacobson »

Thanks
mjacobson
Posts: 204
Joined: Fri Feb 08, 2002 3:35 pm

Can't rank FTN

Post by mjacobson »

boy did that do the trick. Thanks Mark
Post Reply