On 24/02/2011 08:51, Lance Dryden wrote:
> As long as the primary kind of search is either an = match or an in ()
> match, partitioning in markedly improve query speed. See mysql docs
> regarding "partition pruning."
It is an = match on the domain names. This makes them fast enough in
MyISAM.
Regards...jmcc
--
**********************************************************
John McCormac * e-mail: jmcc at hosterstats.com
MC2 * web: http://www.hosterstats.com/
22 Viewmount * Domain Registrations Statistics
Waterford * And Historical DNS Database.
Ireland * Over 240 Million Domains Tracked.
IE * http://www.hosterstats.com/blog
**********************************************************
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
