[thelist] Very Large MySQL Table

Ken Schaefer Ken at adOpenStatic.com
Mon Feb 9 19:28:56 CST 2009

You appear to need indexes and statistics. If you're currently doing a table scan, then having 8 smaller tables isn't going to make much of a difference.

SELECT COUNT(*) should return in a fraction of a second if there are stats available for the table in question.


From: thelist-bounces at lists.evolt.org [thelist-bounces at lists.evolt.org] On Behalf Of Fred Jones [fredthejonester at gmail.com]
Sent: Tuesday, 10 February 2009 12:04 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Very Large MySQL Table

> Unless you have 8 processors and the partitions are not on separate
> platters, running 8 queries instead of 1 will not help - they will just
> each take 8 times longer because they now have 1/8th of the processor
> time.

I meant to break the table into 8 smaller tables and then run the same
search 8 times sequentially, once on each table. Your other ideas are
interesting, however.


* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !

More information about the thelist mailing list