[PATCH] more efficient cache submission query

[dmorton]

The original query used by ham-cache.php and such ran through all of the users cache in a slect, and then issued an update if it was found in the submission. The dgm theme reduces that down to just doing an update per item found in the submission.

An even more efficient way to do it is to do a:

UPDATE maia_mail_recipients SET type=? where recipient_id=? and mail_id IN (?);

where the last parameter is a list of id's... 1,4,7,8,34

This would do only one query, which is much easier on the sql server...

[dmorton]

traffic spikes caused by submission of 100 items.

[dmorton]

This should be easy once #300 is complete

[dmorton]

first running draft