clunk.wercl...@wibblywobblyteapot.co.uk (Clunk Werclick) writes: > > >> >>> It seems lots of lookups per message and I'm not sure that mysql > > >> >>> will not crash like this > > > > Who's to say what "a lot" of lookups are? Why do you think mysql will > > Just Crash? You're far better off looking at the general load and > > responsiveness of your server than checking how many queries mysql is > > doing. > I think perhaps 4-12 queries per message is not optimal? > If server handle 50,000 a day X 12 that is quite a lot? I don't think > it is going to get may fields returned for .co.uk .uk in my database?
A suitably configured mysql backend should easily be able to respond with 5000-10000 queries per second. You'll be delivering a lot of mail when you get to that volume. Perhaps you need to look at your MySQL configuration in this case? Simon
