Uwe, please run that query through an 'ANALYZE' command.
Uwe Kiewel wrote: > Hi, > > I have a crazy slow query. I think it is *not* a slow query. Look at the > time stamp. But, I cannot imagine, why it happened... > > Uwe > > > Apr 12 17:00:53 vm-host postfix-mx/smtpd[13917]: disconnect from > n77.bullet.mail.sp1.yahoo.com[98.136.44.45] > > Apr 12 18:16:16 vm-host dbmail/imap4d[13320]: Warning:[db] > dbmodule.c,db_query(+151): slow query [SELECT 'a',COUNT(*) FROM > dbmail_messages WHERE mailbox_idnr=121 AND (status < 2) UNION SELECT > 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=121 AND (status < > 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE > mailbox_idnr=121 AND (status < 2) AND recent_flag=1] took [4398] seconds > > [EMAIL PROTECTED] ~]# date > Sat Apr 12 17:03:21 CEST 2008 > [EMAIL PROTECTED] ~]# _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
