I would say absolutely! You are sending 100,000 messages a day for this? Is it sending to a remote mail server? If you're building and tearing down a TCP connection for each message, that's a lot of overhead. Not to mention the MTA and file i/o overhead. And if you're spawning an external process to send the mail? If it was just a few messages, no biggie. But 100k is over 1 message per second, probably more during peak times. I'd say that is fairly substantial.
If you're having load problems, turning off those messages is the first thing i'd do to tune the app. But also check the usual suspects when performance tuning (memory, I/O, CPU -- in that order). Can you turn off the messages temporarily to see if load decreases or performance increases? ray -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ray DeJean http://www.r-a-y.org Systems Engineer Southeastern Louisiana University IBM Certified Specialist AIX Administration, AIX Support =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= On Wed, 17 Sep 2003, Alvaro Zuniga wrote: > Hi Guys: > I was sending this message to ask for suggestions about some error checking > and reports about an internet application I am currently working on. > > The applicationg was written to send emails for every transaction that > happens. There are about a hundred thousand transactions taking place daily. > Each transaction requires about two update queries and about three insert > queries. After all this it sends an email report. I would like to add a > query for the transaction to record statistics instead of sending emails. > > My question is, is the overhead of sending an email considerably larger than > an already active database connection with locked tables(mysql). If I invest > the time rewritting this application so that a statistics database exists > instead of sending this emails to the person that does the work out of the > emails worth it? I am mostly concerned with server performance rather than > making someone elses work easier. > > Thanks, > > Alvaro Zuniga > > > _______________________________________________ > General mailing list > [email protected] > http://brlug.net/mailman/listinfo/general_brlug.net >
