> Alexander, > > go ahead and use those fields of type TEXT. Retrieval works like a > charm. > Building the index on large tables may be slow, but the manual gives > some > tricks how to speed things up. As soon as you have VARCHAR fields you > are > into variable record lengths anyway. And you can even have a FULLTEXT > index on all your VARCHAR and TEXT fields. > > Thomas Spahni >
I made something like second MySQL table which contains only the text fields and when I need to select one I have index relation. But I was not sure is it faster than to have the text fields in the same table or it is only unneeded complexity SaS. --------------------------------------------------------------------- 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
