Re: search for query that result one random url from domain
>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.
Subject
Written By
Posted
December 03, 2011 07:52PM
December 04, 2011 04:04PM
December 05, 2011 05:39AM
December 05, 2011 06:42AM
December 05, 2011 07:55AM
December 05, 2011 04:06PM
December 05, 2011 06:28PM
December 05, 2011 07:08PM
December 06, 2011 11:59PM
Re: search for query that result one random url from domain
December 07, 2011 03:24AM
December 08, 2011 08:56PM
December 08, 2011 10:02PM
December 09, 2011 05:31AM
December 09, 2011 01:53AM
December 09, 2011 04:42AM
December 09, 2011 06:31AM
December 09, 2011 07:08AM