2 ms·
1m records? We have 25 million+ in normalized MySql tables with proper indexing and run 20ms queries on modest Xeon E5-1650, 12gig ram dedicated to db, Samsung
by exabrial 12y ago
1m records? We have 25 million+ in normalized MySql tables with proper indexing and run 20ms queries on modest Xeon E5-1650, 12gig ram dedicated to db, Samsung 840 Pro.
Seems like a drop in the bucket to be experiencing performance problems... What are your use cases? Why did you pick MongoDB i the first place?
- bane 12y agoHeck, I have a SQLite dB I'm working with right now that has ~30 million rows across a few dozen tables. Queries against the indexed fields are returning in 130ms on my rMBP.