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]

Reply via email to