Generate Large Amount of Data For Performance Testing

  • Comments posted to this topic are about the item Generate Large Amount of Data For Performance Testing

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • I know this is an old post but thought I'd add a little constructive feedback as to why folks may have graded it low.

    If used for 100 rows, the data is not nearly realistic enough.  All 100 rows are by the same customer with the same OrderDate and the same ShipDate.  That won't help developing a process where there should be multiple customers across multiple dates.  It will also not help with testing performance because the cardinality for the important columns is only "1".

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply