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
