Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Stress Testing

Discussion in 'Information Technology' started by Charles Phillips, Jul 28, 2006.

Tags:
  1. Charles Phillips

    Charles Phillips
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    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

    "Charles Phillips" <tptbusines_2005@hotmail.com> wrote in message
    news:u0HslxDhGHA.3924@TK2MSFTNGP03.phx.gbl...
    > 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
    >
    >
     

Share This Page