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 ...
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 ...
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 (...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 (...
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 ...
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: ...
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 ...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
database × 90automated-testing × 30
selenium-webdriver × 16
manual-testing × 14
test-design × 10
sql × 10
test-data × 9
jmeter × 7
java × 5
api-testing × 5
test-management × 4
performance × 4
unit-tests × 4
tools × 4
etl × 4
load-testing × 3
jmeter-plugins × 3
robotframework × 3
regression-testing × 3
qa-role × 3
aws × 3
testing-environment × 3
selenium2 × 2
python × 2
functional × 2