so I've started working on a project, a web application that in essence generates some ouput-data from data read from an OPC Server (used for process engineering optimization) and finally displays it to the user in different ways. Now, I've written the application in ASP.NET (C#) and I've reached the point where I'm ready to store my data... I've only ever worked with SQL variants (MySQL, SQL CE etc.) when working in ASP.NET but seeing as the data relatively limited, and doesn't need to be saved for more than a few seconds before being updated - It seems a bit over the top to use a full Database?
My idea would then be to have a grid that is connected to a XMLDataSource (my .xml file) which is then updated once every few seconds from a backend method querying the OPC Server.
I've tried reading around on the net, but all I can seem to find is some people saying: "XML is not meant to be a replacement for a Database" and other people saying: "You shouldn't use a full database if you don't need it!" - So I'm kind of stuck in the middle there.
Have you guys got any experience with using an XML Document as a small Database/Cache? And can it handle being queried once every 4-5 seconds?
Hope this makes sense and that I haven't completely missed the point of XML
Thanks in advance,