Hi! I have a daily cron job that fetches various locations(points) from multiple datasets. The model looks something like this:
const PointSchema = new Schema({
id: String,
lat: Number,
lon: Number,
name: String,
zip: String,
addr: String,
city: String,
country: String,
comment: String,
type: String,
courier: String
});
I have around 300k items. My problem is that when i update these, only a handful will actually change day-to-day, so i have like 10 new items, a few with some parameter change(like updated name or address), and a few deleted. What would be the ideal way to handle the update process? Right now i delete everything and just inset all the updated points. You think this solution is optimal, or i should actually check for changes and only update/insert the necessary points?