10 votes
Accepted

Can a proportionately scaled down testing environment find performance load issues?

Does this actually catch, before production, many of the "surprise" problems we might anticipate? Or is there a more fundamental flaw in the approach that will cause deleterious changes to pass ...
Joe Strazzere's user avatar
10 votes

Can a proportionately scaled down testing environment find performance load issues?

No. The items you mention scale very differently and there are far too many factors and resources that will get used. For instance if I time requests on a local server using an application I'll find ...
Michael Durrant's user avatar
7 votes
Accepted

QA testing - Database privileges

It depends on how your process is set up. It makes sense to have read-only access to the Production environment for investigation. Does QA have own copy of the system for integration testing (...
Peter M. - stands for Monica's user avatar
6 votes

Can existing tests and data effectively compare old and new systems?

Yes this is a useful strategy in converting from one system to another as a one time event (it might span a couple of iterations but the idea is very short term). You could effectively view this as ...
Michael Durrant's user avatar
4 votes
Accepted

Should I obtain data required for particular test case using appropriate endpoint or read it directly from the DB?

This depends on what type of testing you implement: If it is a component testing (or if your goal is to test the particular end-point) you should isolate your component from the possible impact of ...
Alexey R.'s user avatar
  • 11.6k
4 votes

What to do if a QA tester mistakenly deleted a table from the QA Database?

It shouldn't be a big deal. Consider another event. You deploy a build to your QA test environment and it has a defect which leads to rows being deleted or even a table being dropped. Should this be a ...
Thomas Owens's user avatar
  • 1,173
4 votes

What to do if a QA tester mistakenly deleted a table from the QA Database?

If you read enough tech Twitter or other tech blogs, you'll come across the sentiment: "You're not a true software developer until you delete production!" Yes, QA testers are developers. ...
Lee Jensen's user avatar
  • 2,051
3 votes

How to perform databse testing in selenium webdriver

Selenium is used for automating user-browser interaction with the HTML and Javascript on websites. It does not have any functionality to test databases other than indirectly through web applications ...
Michael Durrant's user avatar
3 votes
Accepted

How to do more effective database testing?

Reposting from my blog notes Database Testing involves the following Activities for a OLTP System Verify Table Schema, Column names as per Design Document Verify Column Length and DataType Verify ...
Siva's user avatar
  • 2,756
3 votes

Can a proportionately scaled down testing environment find performance load issues?

Test environment will NOT scale proportionally. But what you can do is: make test environment as similar to PROD as you possibly can (with possibly less servers, that's what we do: have about half ...
Peter M. - stands for Monica's user avatar
3 votes
Accepted

Functional Difference between NUnit and MSTest in VS

Check out the answer to this question over at StackOverflow. (From the accepted answer) NUnit has few advantages over MS-Test Suite attribute - can aggregate tests and execute them separately (...
kirbycope's user avatar
  • 4,090
3 votes

What all do we need to test in the application is undergoing a Mongo upgrade?

With any kind of framework or database upgrade like this, after I'd covered system sanity and critical path regression, I would go through the release notes looking for any changes likely to impact my ...
Kate Paulk's user avatar
  • 31.5k
3 votes
Accepted

Using a different database engine for testing

I'm a little out of date using sqllite but data types and stored procedures come to mind as feature gaps between sqllite and something like PostgreSQL. Beyond features, configuration settings (ex: ...
Cherree's user avatar
  • 1,189
3 votes
Accepted

How to create unit tests for Web app with a database

Database shared between tests is a common obstacle. One way ("orthodox") is to insist that unit test should NOT test database (just exercise the tested library), and mock the DB interface. Another ...
Peter M. - stands for Monica's user avatar
3 votes
Accepted

Backend testing

Back-end and back-end testing per se is a complex mechanism. Basically anything that communicates with the server or database is back-end. Another definition can be anything under the hood is back-end....
Rohan Kalia's user avatar
3 votes

Can existing tests and data effectively compare old and new systems?

Comparing the old system to the new system given identical inputs and expecting identical outputs is a legitimate test. There are problems, however: a) When the legacy system is retired, the Source ...
Jerry Penner's user avatar
  • 1,011
2 votes

Can a proportionately scaled down testing environment find performance load issues?

Ideally the best thing is to have UAT or Staging environment which would be exact replica of the production to test your changes there If your application has "dead" time i.e. in the night or during ...
Dmitri T's user avatar
  • 13.4k
2 votes

Is it necessary to verify databases for functional automation testing?

I believe it is a very good idea read back from the database. The reason is that things sometimes (or often) are not quite as simple as they may look. In the example above: what happens if the phone ...
ghellquist's user avatar
2 votes

Should data validation be automated in a rapid development environment

(Full Disclosure.... I work for Pragmatic Works) Pragmatic Works' LegiTest allows for automated Data Validation to quickly verify your data is accurate, error-free, and up-to-date between any two ...
Ryan's user avatar
  • 21
2 votes
Accepted

Designing database reliant tests for parallel execution

Bootstrap a clean environment for each test to test in isolation. This might look like a lot of overhead, but is very needed if you want to parallel run your tests and not get flickering and possible ...
Niels van Reijmersdal's user avatar
2 votes

How to do more effective database testing?

Look into: SQL Injection Load Test (may expose max connections and/or slow queries) Boundary testing
kirbycope's user avatar
  • 4,090
2 votes

Data Validation Testing using selenium

This application fetches huge amount of data from database and displays it on the platform after some simple calculations. Please define huge Please define simple The developers will be able to ...
Yu Zhang's user avatar
  • 9,932
2 votes
Accepted

Cannot load JDBC driver class 'com.mysql.jdbc.Driver' in Jmeter

Most probably you forgot to add MySQL JDBC driver to JMeter (JMeter doesn't include it by default) Download MySQL Connector/J Extract mysql-connector-java-x.x.xx-bin.jar and drop it somewhere to ...
Dmitri T's user avatar
  • 13.4k
2 votes

Efficient way to test data quality of database through java?

You might want to take look at the DataTable of cucumber-jvm since you've been using it anyway. The idea is to use one of its diff methods to compare the expected to the actual state of the database. ...
Mykola Gurov's user avatar
2 votes
Accepted

Compare MySQL and Cassandra?

It's not a difficult problem, as long as you have an OLEDB or ADO.net connector to both your database and Cassandra, then you can write queries on both your source (mySQL) and your target (Cassandra ...
Marcus D's user avatar
  • 320
2 votes

What strategy should follow for Testing after complete data migration process?

If you are doing some kind of ETL of legacy data into a new system, then there are two main things to worry about. First that the ETL logic is wrong, you do not bring over all records you meant to ...
David Cain's user avatar
2 votes
Accepted

How can I Use JDBC Request/Debug Sampler results match with HTTP Response in JMeter?

General recommendation: there are Variable names and Result variable name fields under JDBC Request sampler: Using them you can get "interesting" parts of the JDBC response (or whole response) stored ...
Dmitri T's user avatar
  • 13.4k
2 votes

Automating database testing

I don't think you should be testing each and every record in the database, I would rather suggest considering the following testing types: Positive testing: use criteria which definitely return ...
Dmitri T's user avatar
  • 13.4k
2 votes

Backend testing

Almost all web application will have two components Front end layer (GUI), Backend layer that would contain business logic layer (API), and database layer Backend testing means testing what we ...
Anand's user avatar
  • 786

Only top scored, non community-wiki answers of a minimum length are eligible