For several customer projects I periodically create a new dev database from a production snapshot on AWS RDS. Then I run an anonymizer script over it to change names and email addresses and phone numbers and so on, so the dev data looks real but doesn’t refer to real people. For one big database the anonymizer script can also cull data, so I can set maximum 1,000 customer records (chosen at random) and remove all rel…
May need to test application that speed or latency etc. with 100k or more than so how do you set records that exception?
That kind of testing would not happen on a developer laptop. I normally have a staging environment that duplicates production, including the database. The number of rows in a relational database shouldn’t affect app speed or latency at 10k vs 100k rows. I would expect the number of rows to affect performance logarithmically, if at all.