MySQL Forums
Forum List  »  Backup

Re: Backup and trimming data idea
Posted by: newbie Shai
Date: June 26, 2012 08:46AM

Dear Rick,
Ok I made a mistake here is should be
tblEventAlert needs
INDEX(linkID, eventAlertDateTime). I dont understand why is the index needed for tblLink needs
INDEX(compID, dateTimeStartJourney) isnt we looking for linkID here? For now the tblLink is not having that many data yet but we do anticipate that much of data in future but again for the 3 months time period I dont think so it will be 64k. We dont remove data from tblGeoFence. Yes we need to purge tblLink,tblMainData,tblSubData,tblEmailLog and tblEventAlert. But the decision is made basec on tblLink so from there we need to cascade the delete to rest of the tables. So what is your best suggestion?

Options: ReplyQuote


Subject
Views
Written By
Posted
3533
June 22, 2012 07:34PM
1696
June 23, 2012 05:23PM
1753
June 23, 2012 05:36PM
1775
June 24, 2012 01:51PM
1812
June 25, 2012 10:16AM
1657
June 26, 2012 08:14AM
Re: Backup and trimming data idea
1756
June 26, 2012 08:46AM
1641
June 27, 2012 08:36AM
1738
June 27, 2012 09:03AM
1603
June 28, 2012 11:19PM
1553
June 29, 2012 07:12AM
1560
June 30, 2012 11:50AM
1635
July 02, 2012 09:47AM
1577
July 03, 2012 01:32PM
1620
July 05, 2012 11:13AM
1794
July 06, 2012 09:57AM
1584
July 07, 2012 10:50AM
1604
July 08, 2012 09:33AM
1594
July 16, 2012 08:08PM
1578
July 21, 2012 10:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.