I am a functional analyst that is trying to validate something my developer is telling me. We currently have a 50 GB JSON file that has roughly 200,000 records. This file will regularly need to have 10 records added and another 10 updated. We are trying to figure out the fastest way to rebuild this file.
(Yes, I know a database is an option, but this is a unique case where JSON is needed.)
If I need to update the Grand Hyatt location and create "Wyndam Hotel" on an existing JSON file, is it faster/more efficient to completely delete and rebuild the file or just update it with the changes?
I am wondering if anyone else has run into this. Any thoughts on which method would be faster would be greatly appreciated.