Any Hints/Tips for Creating a Test DB?

Posted by Paul Koufalis on 30-Dec-2013 15:30

I have written a routine that creates random data in the sports2000 DB.  The goal is to create a DB that is somewhat real and that can be used for standardized DBA performance testing for D&L, idxbuild, etc...

What are some things you would expect to see in a realistic test DB?  Some things I have considered:

  • All type II S.A.
  • Most of the data in a handful of tables (3-4 out of 20ish in sports2000)
  • What about random characters?  Effect on index internal compaction?
  • What about string length?  Mix up long and short strings? Doesn't matter?
  • Fill all the fields or some?  I am filling all the fields since I loop through _file and _field
  • How big is big enough for a test DB?  My gut feeling is tens of gigs so that the dump and load and idxbuild times are in the hour-or-more range.  

All comments welcome.

Paul

******************************************
* Paul Koufalis
* Progresswiz Consulting
*
* Email: pk@progresswiz.com
* Phone: 514 247 2023
* Fax  : 514 439 6782
*
* Progress, MFG/PRO, UNIX, Windows, EDI
******************************************

All Replies

Posted by Mike Fechner on 30-Dec-2013 15:33

We had once created a 1GB sports2000 using a random name generation web service and random orders.

Interested in a copy?

Posted by Paul Koufalis on 30-Dec-2013 15:36

Sure!  I think you can post it here as an attachment or just email it to me.

Paul

******************************************

* Paul Koufalis

* Progresswiz Consulting

*

* Email: pk@progresswiz.com

* Phone: 514 247 2023

* Fax  : 514 439 6782

*

* Progress, MFG/PRO, UNIX, Windows, EDI

******************************************

Posted by Mike Fechner on 30-Dec-2013 15:46

will be uploaded in a few minutes.

This thread is closed