4 ms·
Is it possible the data schema is poor? Honestly I may be misunderstanding your description, but 1 collection with 13 indices and 16 basic type fields seems ou
by davismwfl 10y ago
Is it possible the data schema is poor? Honestly I may be misunderstanding your description, but 1 collection with 13 indices and 16 basic type fields seems out of balance to me. And misplaced, misused indices can be a huge issue for any database. You may not see the issue locally on a laptop because of the lack of contention based on the small number of concurrent requests.
- wslh 10y agoNo, the laptop and AWS instance are inserting exactly the same data.
- davismwfl 10y agoThe data may be the same but is the contention? In other words, if you have 100 clients accessing and writing in AWS but only 1 on the laptop it isn't realistic and the schema may still be at issue. How large is the dataset too? Honestly, I know people like to complain about Mongo a lot of times, but frankly I have had really large and small datasets use it and when setup properly with a well designed schema it never was the bottle neck in terms of performance etc. But on a couple of occasions we chose to move away from Mongo because the trade off in schema and machine config to make it work was more of a problem for us.