Raible's Wiki: TestData

At line 1 changed 1 line.

How to generate random test data for your database.

!!How to generate random test data for your database.

At line 3 changed 1 line.

The same system that was designed to handle 100 users will sometimes not work for 1,000 or 10,000 users.

[dbMonster|http://dbmonster.kernelpanic.pl/] is a tool which helps database application developers with tuning the structure of the database, tuning the usage of indexes, and testing the application performance under heavy database load. dbMonster generates as much random test data as you wish and puts it into SQL database. I used dbMonster to add several thousand users to appfuse to test how it will impact performance, especially displaytag peformance.

At line 5 changed 1 line.

dbMonster is a good program for adding data to your system so you can simulate how it will function in production.

%%(color: blue)''What I really love about this system is that it allows me to fill my system with data to see how it would perform with 10,000 to 1 million users.''%%

At line 7 added 2 lines.

----

At line 9 changed 1 line.

I found it easiest to run dbMonster with ant on my system. I'm using Windows XP and cygwin. dbmonster-core was extracted to f:\tools\dbmonster-core-1.0.3 and dbmonster-ant-1.0.1.jar was saved to f:\tools\monster\

%%(color: blue)''

I found it easiest to run dbMonster with ant on my system. I'm using Windows XP and cygwin. dbmonster-core was extracted to f:\tools\dbmonster-core-1.0.3 and dbmonster-ant-1.0.1.jar was saved to f:\tools\monster\''%%

At line 13 changed 2 lines.

mkdir config

mkdir schema

__mkdir config__\\

__mkdir schema__

At line 30 changed 1 line.

Next you want to map the schema of the tables that you want to generate data for. To do this, you will make a new file called appfuse-schema.xml. This example will allow you to generate 1500 new users at a time.

Next you want to map the schema of the tables that you want to generate data for. To do this, you will make a new file called appfuse-schema.xml. This example will allow you to generate 1500 new users at a time. If you want more you can run the application more than one or change ''rows="1500"'' in the file below.

At line 120 changed 1 line.

----

!!Configure Ant

You should put your build.properties and build.xml in the same directory that dbmonster-ant-1.0.1.jar is at.

Here are the contents of build.properties.

At line 130 added 10 lines.

dbmonster.home=/tools/dbmonster-core-1.0.3

dbmonster.ant=/tools/monster

dbmonster.config=/tools/dbmonster-core-1.0.3/config

dbmonster.schemas=/tools/dbmonster-core-1.0.3/schema

}}}

Here is the build.xml file.

{{{

At line 172 added 1 line.

----

At line 155 changed 6 lines.

{{{

dbmonster.home=/tools/dbmonster-core-1.0.3

dbmonster.ant=/tools/monster

dbmonster.config=/tools/dbmonster-core-1.0.3/config

dbmonster.schemas=/tools/dbmonster-core-1.0.3/schema

}}}

!!Run Ant

At line 176 added 1 line.

After you have done the above, make sure your database is started and try running __ant__. If all goes well you should see the following. Try starting appfuse and looking at all the new data.

At line 178 added 7 lines.

__That was easy!:__

%%(color:green)

BUILD SUCCESSFUL\\

Total time: 12 seconds%%

----

Raible's Wiki

AppFuse

Other Applications

TestData