"Jim C. Nasby" <[EMAIL PROTECTED]> schrieb: >Unless that field is actually a "char" or char(), you do not want to be >putting the numbers in quotes. At best, it's an additional cast for the >database. At worst, on older versions it won't cast that automatically, >meaning an index on status is useless. > >In any case, PostgreSQL handles IN the same as ( ... OR ... OR ... ). I can confirm that this makes a major performance difference. I just applied a fix for dspam. They also used the wrong datatypes and merging spam tokes took over 10 hours. After applying the correct databases the merging took only 2 minutes, because now MySQL was able to use indexes.
-- Lars Kneschke Metaways Infosystems GmbH Pickhuben 4 20457 Hamburg Germany eGroupWare Training & Support ==> http://www.egroupware-support.net E-Mail: mailto:[EMAIL PROTECTED] Web: http://www.metaways.de Tel: +49 (0)40 317031-21 Fax: +49 (0)40 317031-81 Mobile: +49 (0)175 9304324
