Re: Database Layout (Design) Question

2007-02-01 Thread sendmail-admin
This isn't exactly what I was looking for, but it works like a charm for both my needs and the sys admins. Go figure everyone is happy now! Many Thanks! -Tyler Kishore Jalleda wrote: The delete would definitely depend upon the size of the record set being deleted, anyway assuming I comprehen

Database Layout (Design) Question

2007-01-31 Thread sendmail-admin
I'm trying to wrap my head around a performance problem our institution is having on our Mysql Server which hosts all of our logs from around campus. Specifically our MailLogs tables. What I'm having a hard time with is we have metadata such as: CREATE TABLE mail00 ( host varchar(32) default