-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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] ~]# -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSADQC9s3frmum9swAQLR/gf8CFvbxSiuN35Eavhb8Z+9SN6j8bsixUiN 2qU2GPV4R2Wbf3K9I/aL5FQ897fcEnl7OW3TDRH9gZHeq5mMr7d4BBxE4vC0fomK YYSFFAnkwofqYMvjdlyVQgrnbEQkmb98J0jO/8diZiLt9OEbiqN0BaOmZUWG9sHb uX/FxgAaPZKx5KDcJDQlvxcLOVGyDflYKLHDAzTbDdyuG9kKILP/UXDMWA3BSKNV NjXuh0+Xbofc7Np9TJaHRG3taNPcbQnyH/uS0MxER8SioBPAvTPPEmyvJ3PY/EtO hSpxGofBxlUGRnarEwn7QBNtmCha4Jn/DfVL/El6uw2tDoMjGfsj7w== =B2Sj -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
