Michael Monnerie wrote: > I make an imapsync to my mailserver, which connects to the PostgreSQL > db, and I get these numbers: > > mailsrv -> db 15.482.309 > db -> mailsrv 648.119.851 > > client -> mailsrv 1.771.458 > mailsrv -> client 15.956.176 > > So with ~18MB IMAP traffic I produce ~663MB database traffic? Can > somebody explain me this?
Interesting figures. Can you produce a base-line? Like say: traffic numbers for syncing a single account, containing a single folder with a single message of a known size, blah blah. Log the query patterns triggered, and the traffic numbers involved. Out of curiosity. Perhaps the explanation will jump out if the logs. One hypothesis a priori: we don't cache as much as we could. In fact, dbmail caches *very* little and will at times happily call the same query a thousand times. And it doesn't even use prepared statements (yet). -- ________________________________________________________________ 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
