Hi Alexander, > I am interested if there any URL I can read more about text type fields > in MySQL. > I had an argument with a friend who said that if I use text type in a > table it will make the system to work to slow. > But I realy needed this text field because I wanted to store text more > than 256 symbols. > And I thought if I make not SELECT * FROM table queries but > SELECT field1, field2 FROM table queries and not to select the text > field every time there wouldn't be problem. > Anybody to know more about this optimization ?
Retrieval from a table with fixed length rows will be faster than a similar row structure involving variable length fields/rows. Was that the tone of your discussion? =dn --------------------------------------------------------------------- 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
