3 ms·
It seems more of a problem with the people than technologies. Why would you need 16 m3.medium (60GB RAM total) to store 600MB of data ? I've used Oracle Cohere
by threeseed 11y ago
It seems more of a problem with the people than technologies.
Why would you need 16 m3.medium (60GB RAM total) to store 600MB of data ? I've used Oracle Coherence and other grid technologies and something doesn't sound right here. It is just a couple of distributed Java HashMaps we are taking about here.
Likewise if 600MB of data is expanding to 12GB in MongoDB then something is very, very wrong with the design of your schema.
- empthought 11y ago> It seems more of a problem with the people than technologies. Isn't that what "lack of understanding of the problem you're trying to solve" means? Though in this case, if the problem had "IP4 ranges" and "geographic data and computation functions" in its scope, then MongoDB is quite inadequate compared to PostgreSQL.
- takeda 11y agoYes problem were people. Too much politics and that's why I left. Why more data? In case of IP geolocation neither of that technology understood IPs not to mention being able to create a proper index for ranges. So in case of Mongo, to get a good performance they decided to generate every possible IPv4 address and map it to zip code. To increase efficiency they stored every IP as a 64 bit integer. In Coherence they did the same thing, but I guess less efficiently (did not look how it was done, since at the time coherence was in the process of being eliminated) I'm guessing maybe they stored is as a string? Also note that Coherence is a distributed cache that supposed to withstand couple nodes going down, so a lot of data was duplicated.