[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