On Thu, 7 Mar 2002 12:03:05 -0000 "DL Neil" <[EMAIL PROTECTED]> wrote: > 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 >
No I was wondering exactly how to construct a table if I need text field and at the same time to satisfy the requirements of a very hi load server --------------------------------------------------------------------- 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
