Re: search for query that result one random url from domain
Posted by:
Rick James
Date: December 08, 2011 10:02PM
A partial solution:
1. Change the charset of domain to latin1. (After all, why would the domain be in utf8 if the url is in latin1?)
2. ADD INDEX(domain, url)
Note: MyISAM has a limite of 1000 bytes for indexes, hence the need to switch to latin1.
This INDEX will allow the subquery to be performed "Using index". If you are currently disk bound, this will help a lot.
Does my query actually provide the 'right' answer for you?
How often do you need to run this query? Does it matter if two users get the same answer? (I am fishing for ways to give the user the appearance of speeding up the query.)
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
December 07, 2011 03:24AM
December 08, 2011 08:56PM
Re: search for query that result one random url from domain
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
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.