Re: search for query that result one random url from domain
>is php really faster than a mysql query?
suck it and see!
>the distinc does not work, cause url is a unique marked field...
>so it would return all urls...
So select DISTINCT domain!
Alternatively, assuming you're using InnoDB, switching to MyISAM might speed things up a little.
I've seen a couple of tricks out there for optimizing this kind of thing, but in my (limited) experience, while very clever, they don't actually make a lot of difference.
Edited 1 time(s). Last edit at 12/05/2011 08:16AM by laptop alias.
Subject
Written By
Posted
December 03, 2011 07:52PM
December 04, 2011 04:04PM
December 05, 2011 05:39AM
December 05, 2011 06:42AM
Re: search for query that result one random url from domain
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
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