> I guess the reason for this is that the I have a some blob fields whitch are > all used.. (each record consist of approx 600 KB...)
There it is. MySQL's MyISAM will get the whole record even if it only needs a part. You can try InnoDB as it does it differently. [At some point I may try and add that capability to MyISAM. I've been researching good ways to compress text and still search it in its compressed state. Then I hope to add the ability of MyISAM tables to automatically compress TEXT/VARCHAR/CHAR (non binary) fields without worrying about uncompressing everything if someone does a LIKE on that field. BLOBs can use gzip type compression. And neither the data nor decompression should occur if the field is not used. When I get more time...] However, back to your issue. Have you tried adding INDEX(ProductionYear,ID)? That would prevent MySQL from having to read the datafile at all, since it could find everything it needs in the index file. My speed guesses: o If you didn't change the structure of the table or add an index, then switching to InnoDB would improve performance quite a bit. o Adding an index(ProductionYear) to the above InnoDB table would speed things even more. o Adding INDEX(ProductionYear,ID) to the MyISAM table would be even faster still. -steve- http://Network54.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
