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
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehended your situation correctly ,I would
suggest using the Merge storage engine for your needs , and keep every
single day of data in a seperate MyISAM table, and merge all those tables
into the table.
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 8:51 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Database Layout (Design) Question
The delete would definitely depend upon the size of the record set
In the last episode (Jan 31), [EMAIL PROTECTED] said:
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