MySQL Forums :: General :: search for query that result one random url from domain
Re: search for query that result one random url from domain
Posted by: laptop alias ()
Date: December 07, 2011 03:24AM
>I don't know about speed
If you don't, no one does!
But RJ touches on a fair point - one I overlooked - which is that a million rows is peanuts to MySQL so any way you cut it, your query should take no more than a few seconds.
Try his query, and if it's still slow paste the result of EXPLAIN SELECT... here together with your CREATE TABLE statement.
If you don't, no one does!
But RJ touches on a fair point - one I overlooked - which is that a million rows is peanuts to MySQL so any way you cut it, your query should take no more than a few seconds.
Try his query, and if it's still slow paste the result of EXPLAIN SELECT... here together with your CREATE TABLE statement.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates