I'm having trouble getting a query to obey LIKEPROWS.
<sql "SET likeprows = 20;"></sql>
<sql "select id from table where flag='0' and textfield likep $pterms "></sql>
I'm finding that LIKEPROWS will not operate when the WHERE includes the flag field -- btree index. I get 8000 results even with LIKEPROWS set to 20. Is there a way to get around this?
With other conditions in play Texis may need to look at more rows to make sure you get some results out, so LIKEPROWS may not be able to limit the results. Depending on what you are trying to do creating appropriate indexes, and changing the order of the where clause can help.
I have allmatch turned off. If the likep is going to return 10,000 bills and I have max=20, is it giving me the best 20 matches or is it cutting off processing before it fully evaluates and ranks the 10,000? In that case it would be better for me to keep the 10,000 in the set.