Hi, I am trying to optimize my data and am currently looking at indexes etc. Someone has suggested the following as well:
1. Ensure that there is no whitespace at the beginning or end of entries 2. Use 1 or 0 instead of yes or no. If point 1 is true then is there a way to trim all whitespace data? The problem I see with point 2 is it makes querying the data more awkward to replace every 1 with a yes and 0 with a no. I would be most grateful for your comments on this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]