/    Sign up×
Community /Pin to ProfileBookmark

How to stress test a website with SQL searches.

Copy linkTweet thisAlerts:
Apr 29.2015

Ok so I have a website that does a lot of searches through SQL. Basically it’s a form that you submit and it gathers information from a SQL server. Like for instance looking up Address information.

So a normal stress tester that just goes to index.php and tells me how long that takes to load is no good. I need something that records steps.

I have tried about half a dozen tools by now.

Storm Runner is pretty good but the results they give me really suck. It’s basically a “speed test” doesn’t tell me anything about how long the site takes to load. Which is a real shame because the rest of the package works pretty well. I tried a few others but they all have deficiencies. Most of them I set up the process to go to my site and do a search. But when I actually run it I don’t see any load whatsoever on my SQL server. Which tells me it’s not actually doing what it’s supposed to do.

It doesn’t have to be a complicated tool with a bunch of bells and whistles. In fact I would prefer something simple. It just has to work! And I’m really having a hard time finding something.

Thank you ahead of time.

to post a comment
Full-stack Developer

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@NogDogApr 30.2015 — [url=http://jmeter.apache.org/]JMeter[/url] might be worth a look, and its price is right.

PS: If you're not seeing much load on the DB server, make sure your tests are designed to present different query values, since if you make the exact same request over and over, it may well be caching results and responding from them as opposed to actually running new queries.
Copy linkTweet thisAlerts:
@gliniusMay 09.2015 — If you're looking for a free/open-source tool which provides record and replay functionality consider the following:

  • 1. Grinder

  • 2. Gatling

  • 3. Tsung

  • 4. Apache JMeter


    • Check out Open Source Load Testing Tools: Which One Should You Use? guide to consider the right option.

    Remember that recorded test scenario may not be replayed well enough due to dynamic request parameters. If you go for JMeter make sure that first time you run test in GUI more with 1 thread only and having View Results Tree listener enabled so you could verify that the test is doing exactly what it needs to do.
    Copy linkTweet thisAlerts:
    @PaulBarattoMay 20.2015 — Hi,

    First of all generating representative load on a database by interacting with the GUI of the application requires to generate relevant load.

    Generally real users searching for information on Websites are using different types of keywords, different types of searches, etc. Therefore, generating load with users that always search for the same content would only reach the cache of your database.

    So it is very important for your projects to use a load testing solution able to conduct realistic tests and having features such as:

    - Ability to design, import dataset

    - Monitor your infrastructure and send alerts if one part of the architecture is reaching critical thresholds

    - SLA on response times, errors

    - generate load from your local network or from the cloud

    - ability to easily generate reports

    I suggest you to look at the Free Edition of NeoLoad. It's a load testing tool with all the features you need.

    http://www.neotys.com/product/overview-neoload.html

    NeoLoad would be one of the best solutions to easily implement your tests.

    Moreover, it’s a very easy to learn and fast to implement solution. You'll then

    have more time to focus on learning the fundamentals of load testing.

    Take a look!

    Paul Barrato
    ×

    Success!

    Help @nick050183 spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 6.17,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @nearjob,
    tipped: article
    amount: 1000 SATS,

    tipper: @meenaratha,
    tipped: article
    amount: 1000 SATS,

    tipper: @meenaratha,
    tipped: article
    amount: 1000 SATS,
    )...