Hello.
In my humble opinion, the design of the database should not depend on operators which you're going to use in your queries. Yes, using INTs in the IN clause (that means the the column type is INT as well, isn't it?) should be a bit faster, because operations with strings are in general slower than with numbers. Test USER wrote: > When using IN should i design the database to use int's or is the performance > equal? > > WHERE col IN('test','test2','test3') > vs > WHERE col IN(1,2,3) > > > ------------------------------------------------- > FREE E-MAIL IN 1 MINUTE! > - [EMAIL PROTECTED] - http://www.pc.nu > -- 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]