All geek questions in one place

How do you simulate frequent database activity for realistic testing?

I am creating a web application for a database where a small number of records are recorded simultaneously (about 5000). Each active work record is likely to experience 50-300 changes per 30 users over a 4-hour period ... that amounts to thousands of changes per minute.

Since our test environment is so static, testing is not realistic, and some problems do not arise until we get into the production database.

I had the idea of ​​starting the profiler, compiling the DML instructions, and then playing them on the test server while debugging the application ... Assuming that I can play them at the same time intervals as the original. But even this will not be a valid test, since changes to the tester may lead to the replay of future DML statements.

Does anyone know how to simulate real-time database changes for realistic testing?

Thanks.

BTW. Our problems are not concurrency problems.

+3
source share
3 answers

Perhaps you need this Selenium-based service: browsermob

Few recommended it.

, :)

+1

, . Quest Software, , , , Quest:

Visual Studio, - , Visual Studio Test Edition. , Benchmark Factory.

0

Perhaps use something in line with database stress testing tools like mysqlslap load emulator. Here is a link explaining use cases and specific examples.

0
source

Source: https://habr.com/ru/post/1702831/

More articles:


All Articles