Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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. OP
    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
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page