- Joined
- Nov 8, 2013
- Messages
- 3,378
- Likes received
- 648
- Thanks received
- 177
If your data is too generic then your queries may not be selective enough to use indexes and you may have performance issues you would not get in production. Or if your test data is too random then indexes may be used that would not in production.
Contention due to data distribution is an issue to be aware of too. I've build a system before that ran like treacle through a sieve in test. it turned out that they were putting through hundreds of TPS using only 50 credit card numbers. When they added more credit card numbers it flew.
