Wow. Sounds like you have a heck of a job ahead of you, Alvaro. Reminds me of "The Charge of the Light Brigade".
"Into the valley of Death Rode the six hundred." :) John Hebert -----Original Message----- From: Alvaro Zuniga To: [email protected] Sent: 9/17/03 11:44 AM Subject: Re: [brlug-general] mail vs database for stats 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
