Hi,
I'm just trying to make sure I am going about this the right way.
I have a group of String IDs , strings up to 31 characters long, case-insensitive, trailing spaces allowed. I've got these IDs in their own table, to specifiy a numerical ID.
So I have a numerical ID and a String ID in a table that will get heavy use. I tried using a CHAR() column, but ran into the trailing space issue so switched to a TINYTEXT with a UNIQUE index on the first 31 characters. Can anyone think of a better solution?
From the documentation it appears that a TINYTEXT is still getting stored separately from the rest of the table. Would the 31 character index negate any need for MySQL to read the full column information? This table will get heavy use, in checking to see if a String ID exists, and creation if it doesn't.
Thanks, Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
