Behaviour of limit

[mrblom]

Say you set a search to have a limit 100, will the search stop executing and return the 100 first hits, or will it continue to run through all the possible hits.

If the first is the case... Why should it take longer time to search for example "SELECT something FROM table WHERE name like 'php*' limit 100", than if you use "name = 'phpbuilder'"?

Of course i can see why this should be different, but still I'm thinking that what I ask for in the first search is to list the first 100 hits that starts with "php"... Why does this hav to take longer time than the first 100 hits called "phpbuilder"...

Maybe this is a stupid question, but having the need of retrieving data fast... very fast... Is there something I can do to optimize my use of queries? Anybody?

Ok

[notionlogic]

Firstly I assume you mean 'php%' and not 'php*'? unless I've missed something along the way 🙂

Secondly the reason that it's quicker is that an exact match "using =" will always run faster than a partial match using LIKE

Unfortunately if you want a more technical explanation you'll have to read the manual - I can't explain it, I just KNOW it's faster ! 😃