MySQL Forums
Forum List  »  General

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
Re: search for query that result one random url from domain
December 05, 2011 07:55AM


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.