Servers, accelerated JSON programming time with File I/O vs SQL Database OLE-DB
Published: Monday, April 6, 2020 written by Andy Flagg
View Count: 53
Keywords: Server 2019, JSON programming, File I/O, SQL Database, OLE-DB, Abandoned Data, Stale Data
For the last 60 days, I have been contemplating the JSON programming for accelerated File I/O versus SQL Database OLE-DB.
Which would be faster, safer, more secure?
SQL OLE-DB is the fastest in RDBMS terms - it's native raw SQL so no intermediary calls.
However, File I/O can be faster and more efficient.
It depends on the security model in the JSON stream and how encrypted we want to keep our data alive and clear out stale or abandoned data.
Yes, I said it - Abandoned data. We need to think about cleaning up abandoned data.
For nearly 25 years, I have cleaned up abandoned data that has been trace logged and that is all that is needed for security and audit purposes. Can we automate the clean up? sure!
more to come...
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.
© 2020 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.