On 25 Sep 2002, at 16:28, Brent Baisley wrote: > Your biggest speed benefit can actually be attained by avoiding varchar > and text fields altogether, use char(). This will cause each record to > be exactly the same length, which will allow MySQL to "jump" to spot in > the file quicker. It's less efficient on space usage, but storage is > cheap.
If Derek is using a MEDIUMTEXT column, presumably he sometimes has more than 65,535 bytes of data in that column, so CHAR is not an option. Besides, with indexes MySQL has the right spot to jump to available even if you don't have fixed-length records. [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- 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