Like performance

Speed issues when searching with like

[justageek]

select * from db where car = 'porsche'

Will be fast if an index is used.

select * from db where car like 'pors%'

Will compare to the first example how? Will it be just as fast or slower? Thanks.

JAG

[brucec]

LIKE uses slightly more system resources than a plain equals, since the database has to find the stems.

[whats up skip]

Can you please give an example where you have successfully used the like command in a text search via php?

I have been trying to do this but with no luck.

[justageek]

What hasn't worked for you exactly? The first example I used works fine.

JAG

[jamesa]

In MySQL, this:

select * from db where car like 'pors%'

shouldn't cause much of a performance hit because the way indexing is done. This would, though:

select * from db where car like '%pors%'

On the other hand I've noticed that full text indexes to be very fast, so in the latter example full text indexing might be a good option to explore.

[justageek]

I've been happy with the fulltext indexes also. The problem I have is that I have about 1.5 billion pages to index and I'm trying not to go the fulltext route. I'm experimenting with some different things and was trying to figure out my best options :-)

JAG