[thelist] Very Large MySQL Table

Fred Jones fredthejonester at gmail.com
Mon Feb 9 19:04:21 CST 2009


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



More information about the thelist mailing list