speed query or fetch the results
Posted: Thu Oct 20, 2005 3:56 am
I have a problem with the speed query and with the speed of the load af the page.I have a search engine with 2GB database so you can see my problem is real big.I have read many things but nothing helped that much.Explain select doesn't help me.The query looks like:
[SQL]
select name,.... from firme where ...(('$name'='')or(Name REGEXP '[[:<:]]".$name."[[:>:]]')or(Name='$name'))...
[SQL]
In the select after where I have 6 conditions like the one above after other fields.Explain select doesn't help me.Any ideas of how I can speed the query or the fetch of the results in MYSQL?
Is there a way to show the first results of the page and the page to continue loading after that?
[SQL]
select name,.... from firme where ...(('$name'='')or(Name REGEXP '[[:<:]]".$name."[[:>:]]')or(Name='$name'))...
[SQL]
In the select after where I have 6 conditions like the one above after other fields.Explain select doesn't help me.Any ideas of how I can speed the query or the fetch of the results in MYSQL?
Is there a way to show the first results of the page and the page to continue loading after that?