#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,672
    Rep Power
    171

    What is the best way to create dummy data for database testing


    Hello;

    I am going to experiment some design and indexing on a
    database. There are 1.000.000 customers, 200.000 orders and 50.000 products.

    What is the best way to populate such database with dummy data?

    Thanks
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    Write a PHP script to insert them.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  4. #3
  5. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,672
    Rep Power
    171
    Originally Posted by E-Oreo
    Write a PHP script to insert them.
    Hey man how r u?

    Yes I thought of that and numbers are fine.

    But I want the data to look kinda real. You know what I mean. For example differnet names.

    How would you enter 1 million first name and last names that look real. Its just more fun to work with real dummy data.

    Not a big deal. I thought there should be a source somewhere.

IMN logo majestic logo threadwatch logo seochat tools logo