Hi! > 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...)
Yes, it's the reason. 600K per record... > But since I donesn't include any of the blob fields in the SELECT statement > I can't see no reason why MySQL should scan all the fields. Because MyISAM always reads the record as a whole, it cannot read only selected fields. You can convert your table to InnoDB table type - as InnoDB *can* read only selected fields. Actually, it's useful optimization to store big, rarely selected fields in the separate table. This will also help to speed things up. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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