Paul J Stevens <[EMAIL PROTECTED]> said:
> One side note though, Aaron. I saw in the is_header code you added to user.c > that you still issue one update query per messageblk. That is very much > suboptimal. We should work toward: > > update dbmail_messages set recent_flags = 0 where message_idnr in (a,b,c, ... > N); > > where the IN (...) list can be quite long, possibly upto a few hundred idnrs. I'll make the change this afternoon. I'll use the same sort of modulus that I'm currently using to print 5 message numbers per line, and pick a reasonably small number for the query, maybe 50 at a time? Aaron
