in reply to Re: Combining Ultra-Dynamic Files to Avoid Clustering (Ideas?)
in thread Combining Ultra-Dynamic Files to Avoid Clustering (Ideas?)
"You cannot insert data into the middle of a flat file."
Is this an actual limitation, or are you saying that this is a bad idea?
"I would use a database like SQLite"
My concern is how the database would do this. Wouldn't it be doing the exact same thing?
Also, since the only way to append to a BLOB that I've seen is to do an "update . . . set this_blob = concat(this_blob,new_int)", wouldn't that be even less efficient?
In Section
Seekers of Perl Wisdom