matt ryan wrote:
If I well understood, You have in Your index almost all data, You have in Your table?The table is 9 gig, and the index is 8 gig
unfortunately the primary unique key is almost every column, if I were to make it one using concat, it would be huge.
I tried making those fields a hash, but it did not work, I had duplicate hashes for non duplicate records!!
Matt
Why not add field for unique key (auto increment if You want less work)?
It reduces size of Your primary index and thus speed up working with it!
Best regards
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]