Hi, I read the document about Static table and Dynamic table. When we have VARCHAR, BLOB, and TEXT, default is Dynamic. But if we don't have BLOB, we can force MySQL to create static table. Now my question:
There is a table with more than 150000 records and about 130 fields and there are some fields with text type. This table is very handy and everyday is being changed and used in queries. Speed is more important than size for us. What type do you recommend for this table? Static or Dynamic? if static, what should I do with text fields? Should I leave them in this table or create another related table and move the text fields to it? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]