On Fri, Jul 18, 2003 at 12:55:12AM -0600, Martin Foster wrote:
The other table follows a sequential order and carries more columns of
information. However, this table clears it's entry nightly and with
current settings will delete roughly a days traffic sitting at 50K rows
of information.
Martin Foster [EMAIL PROTECTED] writes:
My question is, should the purging of rows be done more often then once
a day for both tables. Is this why performance seems to take a hit
specifically?
Given that the hourly purge seems to work well for you, I'd suggest
trying it on both tables.