Skip navigation links

MySQL Forums :: General :: search for query that result one random url from domain


Advanced Search

Re: search for query that result one random url from domain
Posted by: laptop alias ()
Date: December 05, 2011 07:55AM

>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.

Options: ReplyQuote


Subject Written By Posted
search for query that result one random url from domain Bernd Meier 12/03/2011 07:52PM
Re: search for query that result one random url from domain Bernd Meier 12/04/2011 04:04PM
Re: search for query that result one random url from domain laptop alias 12/05/2011 05:39AM
Re: search for query that result one random url from domain Bernd Meier 12/05/2011 06:42AM
Re: search for query that result one random url from domain laptop alias 12/05/2011 07:55AM
Re: search for query that result one random url from domain Bernd Meier 12/05/2011 04:06PM
Re: search for query that result one random url from domain laptop alias 12/05/2011 06:28PM
Re: search for query that result one random url from domain Bernd Meier 12/05/2011 07:08PM
Re: search for query that result one random url from domain Rick James 12/06/2011 11:59PM
Re: search for query that result one random url from domain laptop alias 12/07/2011 03:24AM
Re: search for query that result one random url from domain Bernd Meier 12/08/2011 08:56PM
Re: search for query that result one random url from domain Rick James 12/08/2011 10:02PM
Re: search for query that result one random url from domain Bernd Meier 12/09/2011 05:31AM
Re: search for query that result one random url from domain laptop alias 12/09/2011 01:53AM
Re: search for query that result one random url from domain Bernd Meier 12/09/2011 04:42AM
Re: search for query that result one random url from domain laptop alias 12/09/2011 06:31AM
Re: search for query that result one random url from domain defor rest 12/09/2011 07:08AM


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.