General rule of thumb: ignore everything unless it's an exception. I would look into using something like procmail to filter through those messages, archive normal ones, and then just forward exceptions to a real person. You could cut through the useless ones, make sure a real person sees the important ones, and *still* have an archive of all mail messages.
At 11:44 AM 9/17/2003 -0500, you wrote: >Thanks Dustin: >That is a very good quetion. I believe the emails are stored in folders and >they are accessed as need basis and deleted after some period of time. I know >it is a terrible idea buy it is already in place. I am looking forward to >change that. It will be fun because this interacts with about 320 databases >controlled by a cronjob that runs every minute. Some email is processed here >and then some data is posted to another server which is the one generating >most of the emails. The emails contain the information of every monetary >transaction which could better managed the simple way, a database and an >interface. I wonder who came up with that but I am sure this person never >imagined this will grow to this extent. > >Take care, > >Alvaro Zuniga > >On Wednesday 17 September 2003 10:27 am, Dustin Puryear wrote: > > At 12:26 AM 9/17/2003 -0500, you wrote: > > >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. > > > > I would definitely record the information in the database rather than send > > an email. If nothing else you need to consider the amount of time taken to > > startup a new process to transmit the email vs. the already running process > > that is updating the database. > > > > Who the heck is reading all of these emails? Man, that job must suck! > > > > "Cool, only 230,234 emails to go and I can grab some lunch." > > > > > > --- > > Dustin Puryear <[EMAIL PROTECTED]> > > Puryear Information Technology, LLC <http://www.puryear-it.com> > > Providing expertise in the management, integration, and > > security of Windows and UNIX systems, networks, and applications. > > > > > > _______________________________________________ > > General mailing list > > [email protected] > > http://brlug.net/mailman/listinfo/general_brlug.net > > >_______________________________________________ >General mailing list >[email protected] >http://brlug.net/mailman/listinfo/general_brlug.net --- Dustin Puryear <[EMAIL PROTECTED]> Puryear Information Technology, LLC <http://www.puryear-it.com> Providing expertise in the management, integration, and security of Windows and UNIX systems, networks, and applications.
