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 :-\
Anyways, try the query with the quotes removed from around the numbers
and see if you see anything different!
Aaron
On Tue, 2006-11-07 at 09:39 +0100, Lars Kneschke wrote:
> Hello!
>
> I'm still searching for performance bottlenecks. And i discovered
> another one.
>
>
>
> I'm using mysql 4.1 and not the latest SVN snapshot of dbmail.
> Hopefully this code did not change in the last 3-4 weeks. :-)
>
>
>
>
> When searching for the subject, we are creating following query:
>
>
>
> SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p
> ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON
> v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id
> WHERE mailbox_idnr = '100' AND status IN ('0','1') AND headername LIKE
> 'subject' AND headervalue LIKE '%gentoo-%' ORDER BY message_idnr
>
>
>
> This query tooks 15 seconds to finnish. :-(
>
>
>
> The machine executing this query is really, really fast and has much
> ram.
>
>
>
> I'm still trying to analyse this problem. Just want to let you know.
>
>
>
> ______________________________________________________________________
> 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
> _______________________________________________
> Dbmail-dev mailing list
> [email protected]
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
