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

    Join Date
    Mar 2004
    Location
    Nobbies beach, Gold Coast. It's beautiful.
    Posts
    2,575
    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,301
    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
    Nobbies beach, Gold Coast. It's beautiful.
    Posts
    2,575
    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