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 !