Database Load Testing

[rrgayhart]

Size: 5

In addition to handling heavy request load from users, our applications will need to handle database load against a db with large numbers of records. To do this, we'll need to seed the various tables in our DBs with lots of records.
Writing your seed script won't be too difficult, but running it can take some time, so it's recommended that you get started on this part early. Additionally, Ryan Bates' Populator Gem may be worth a look.

Acceptance Criteria:

• Create a 'seed' script that creates the following
• 500,000+ "Job" records
• 200,000+ "Company" records
• 300+ "Technology" records

Choice 1

• Create and deploy a staging server (if one does not already exist)
• Update the README with the staging server location
• Set up New Relic on the staging server (if not already set up in Add New Relic to Monitor Performance #7)
• Run the seed script and document the application's performance against the load

Choice 2

• Have a flag in the database or a timestamp that differentiates fake records from real ones
• Write said script
• Run the script during non-peak times
• Have another script or rake task that cleans up the fake records