• Ingas (unregistered) in reply to LintMan

    Suppose user table with such structure:

    user_id user_name 1 John 2 Mary 3 John 4 Mary

    Suppose you have a table with user actions Action user_id Action1 1 -- John Action2 2 -- Mary Action3 3 -- John another time

    Suppose you have hundreds of such action tables If you want to clear user table - you must make all other history tables correct. Some information may be years old, some records may be already archived, some records may be replicated to other systems. It's not so complex, but it can be a great deal of painstaking work.

    (And I think such work is very needed, except only if system functioning last days)

  • (cs) in reply to JUST ANOTHER WTF

    I think this is a Dilbert "I budgeted some goons to beat [the requirements] out of you" situation.

    Re: 1000xdaily import - Oh, sure, and then get boned because the end-of-day file is much smaller than the end-of-week/month/quarter/year file.

    Working at "No Need To Change It" let me see how mystery files you import periodically have a nasty tendency to vary like crazy based on external factors... i.e. dealerships do much more business in July than in February.

    Besides, even if the file actually received is only 2x your original, that gives you 500 days of input before the horrible maintenance procedure has to run.*

    • I'm figuring this is a situation where you'd like to quit before the space limit gets hit.

Leave a comment on “Cross Your Fingers ...”

Log In or post as a guest

Replying to comment #:

« Return to Article