Aaron Stone <[EMAIL PROTECTED]> schrieb: >Lars, this code has changed subtly, but significantly this month: >there are no more quotes around numbers. I tried your query on my >mailbox, and the time went from 40 seconds to 5 seconds. Then I tried it >again and got a result in 0 seconds. Which means you can't trust my >40->5 results because my queries are cached. 'flush query cache' did not >actually flush the query cache, so I have no clue what's up :-\ set session query_cache_type=0; is your friend. :-) > >Anyways, try the query with the quotes removed from around the numbers >and see if you see anything different!
I tried already without the quotes, but that did not change anything on my installation. The query took 14.29 seconds. I'm waiting for my brother to wake up. He will able to explain how this query can be optimized. At least i hope so! :-) -- 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
