Hi Paul,I'm not sure if dbmail has any kind of caching but even without caching I think there is someing wrong.
I attached a mysql query log of 3 or 4 seconds compressed using: cat mysql.log | grep -v Prepare | sort -k 2.7 | uniq -c -f 1 | sort -hand reduced for all query that are occur only one time or are not informative.
The attached log seams to show 2 users, both uses Outlook 2013 and maybe more devices.
I can't understand why dbmail has to query 133 types the same 8 queries. Also this query should only be necessary or?411 99720 Query UPDATE dbmail_messages SET recent_flag = 0 WHERE message_idnr IN (4921787,4921795,4921805,4921954,4923942) AND recent_flag = 1
but it get 411 executed.Just for information I see 2 Database connections 99720 and 99721 (here combined as one) but they execute the same statements (not at the same time).
This should not be normal or? Atm I have 75000 Database query in 5 seconds. thx -- Harald Leithner ITronic Vogelweidplatz 12, 1150 Wien, Austria Tel: +43-1-786 23 88 Fax: +43-1-98 52 077 Mobil: +43-699-123 78 4 78 Mail: [email protected] | itronic.at
query.log
Description: Binary data
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
