james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "robert burrell donkin" <robertburrelldon...@gmail.com>
Subject [IMAP] MessageRow and MessageFlags
Date Mon, 12 Mar 2007 20:56:33 GMT
i've been experimenting with indexes recently. so, i've spending some
time going though SQL logs looking for table scans. there are a lot of
joins from message to message_flags which result in unnecessary full
table scans.

i think that message and message_flags are joined one-to-one. this is
inefficient. is there a good design reason why message and
message_flags are separated?


To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org

View raw message