Stress Testing

[Charles Phillips]

Hello,
I'm developing a MS-Access 97 database for about 50 Users on a Windows
network.
I'd like to know, if there is a standard set of test to perform on the
database for verification.
Are there processes to test CPU utilization, memory utilization, processing
time & whatever else there is needed to validate your database...

If there is a set of standard stress test, what are they, where can I find
them & how long should you stress test a database before you give it to your
customers or go public with it???


Thank you,

Charles L. Phillips

 

[Arvin Meyer [MVP]]

Create a table ("tblTestRecords") with a field ("Numbers") Then run the
following function from the debug window, like: (feeding it a million or so)

? GimmeABunch(1000000)

If you have a small table with 10 or 15 records build a query with a
Cartesian product join between the TestRecords table and you 10 record table
(just put both of them in a query without a join, and you'll get 10 million
records) Put the data tables on a server and start having users open the
query up. That's all the stress you'll need to test for.

Public Function GimmeABunch(y As Long)
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim x As Long

Set db = CurrentDb
Set rst = db.OpenRecordset("tblTestRecords")

For x = 1 To y
rst.AddNew
rst!Numbers = x
rst.Update
Next x

MsgBox "Done!", vbOKOnly, "Records Added"

rst.Close
Set rst = Nothing
Set db = Nothing

End Function
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access