[thelist] Very Large MySQL Table

[Ken Schaefer]

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.

Cheers
Ken

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

Thanks.
--

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

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