While pondering the "snappyness" issue, it occurs to me that the overhead is most likley the manipulation of the actual files and embedded metadata, rather than the database itself.
Which makes me wonder if perhaps an option to queue updates to the files until idle / scheduled time / commit command might make sense.
|