MySQL Forums
Forum List  »  General

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: search for query that result one random url from domain
December 07, 2011 03:24AM


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.