Hello. You will get much more help from the list if you provide the current table structure, short description of the information which is stored in that fields, and the query you want to optimize (most probably it takes much more time than others).
> If point 1 is true then is there a way to trim all whitespace data? There are LTRIM and RTRIM functions. See: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Shaun wrote: > 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. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
