February 22, 2011 at 11:01 am
Please could someone help with the Immediate decision..
we have an application and there are 500/600 Users who access the application.
There are around 30 to 40 main tables exists for the application.
some tables have 5 million,some have 10 million and some tables have more then 40 million records....
my manager would like to know if any change happened in any of the row/column in any of the table...if yes then she wants to have the old record saved some where.....
for example: we have a Customer table...which has 40 columns in the table....
if any one of the column/row value has been changed by any user then i have to keep track of the old record...
Below are my Ideas...
I can write trigger on 30 to 40 tables...
but below are the problems...
It makes the application slow...and some records are updated by import process from the web services ...so they cannot
handle by the trigger....
i thought of mainting the history tables were i will be loading the records which been updated daily...but some of the tables do not have the modified date...so i do not know what record has been updated in that table....and if i keep on inserting the records into the history tables...then the table might keep on increasing the volume...
In the meeting team had couple ideas...they want to remove the update button on all the modules on the application...
and to remove the web services option for the users ...which will not have the update option ...If the user wants to update anything on the application..they will not be able tooo...they can only add new records...
But they did asked me instead of removing the update option on all the modules on the application...Is there any other way
that i can do from database side...that i can keep track of any column/row changes in any of the table in that database...
Could someone please help me with some suggestions...i have to update the team as soon as possible...
February 22, 2011 at 11:02 am
Please don't double-post.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 22, 2011 at 11:11 am
I am sorry...
I was confused and posted at both places....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply