October 13, 2004 at 5:40 am
I'm currently working on a piece of software using MSDE where the correctness of the data stored/retrieved are critical. An issue was raised in this project regarding how much we can rely on that the data we store is the same data we read from the database? Do we need any additional data validation mechanism like CRC's?
Has anyone seen any evaluation or calculation of the probability that the data can been corrupted along the way to/from the disk storage to the application?
October 13, 2004 at 1:09 pm
Majority of any issues were data actually is corrupted is application not SQL, otherwise you should get errors. I however wouldn't use MSDE for anything critical as it is a lightweight system designed to not be too overstressed, you could find yourself call to reinsert or reread often based on the number of concurrent things reuqested and the number of connections doing the requesting. Beyond that you probably would need to call MS for any insight they can offer.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply