Stress Test Database (4 million rows of fictional data) (1 Viewer)

Status
Not open for further replies.

Banana

split with a cherry atop.
Local time
Today, 10:36
Joined
Sep 1, 2005
Messages
6,318
Here is a tool that can help in avoiding situations where you delivered your database and two months later the client is complaining that it takes FOREVER to get anything done. Is Access really that bad, or is it your code?

This is a sample database developed by Patrick Crews and Giuseppe Maxia and provides a combination of a large base of data (approximately 220 MB) spread over six separate tables and consisting of 4 million records in total adapted into an Access database.

The database can be useful in assessing answers to various questions such as

  • Which general classes of SQL statement (e.g. Joins or subqueries) will perform better?
  • How does Access use index and how efficient it is under what conditions?
  • How well will it perform in a networked environment?


...among other things.

While it may always not be the answer to every questions, it can be useful in answering questions that is best answered with a dataset consisting more than ten rows worth of data and understanding how Access manage such load.

The schema is given as below:


It should be noted that authors left up to the users to modify schema and find the inconsistencies in the data. If you do elect to modify the schema note that the best way going at it would be to create a new blank table, define relationships and indexes to the blank table first then run an append query moving the data from old table to new table. Altering table in design view may be possible but in my experience, usually takes up to 20 minutes before quitting with a "System resource exceeded." error which is frankly a big time-waster.

The database is licensed under Creative Commons Attribution-Share Alike 3.0 Unported License, and is free to distribute & share provided the conditions given in the link.

Adam Taylor was kind enough to host the files at his United Kingdom site:
Driffield Computing.

Employees2000
Employees2003
Employees2007

Bob Larson was kind enough to host the file zipped into 70 MB at his Western USA site: btabdevelopment.

Employees2000
Employees2003
Employees2007

George Hepworth also was more than happy to host the files as well at his Western USA site: GPC Data site:

Employees2000
Employees2003
Employees2007
 
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom