Skip to main content

Timeline for An XML file or Database?

Current License: CC BY-SA 3.0

5 events
when toggle format what by license comment
Apr 5, 2012 at 6:38 comment added webnoob Many thanks. Should be able to have the best of both worlds now. The speed with being able to get the data by index and no Sql overhead.
Apr 5, 2012 at 6:10 comment added Daniel B @webnoob - I think you're on the right track. If you're going to create your own cache (even if it's just a public static variable somewhere), it's a good idea to understand the basics of concurrency, since an ASP.Net environment is multi-threaded by its very nature. Read up on the lock keyword a bit, it's probably the easiest way to achieve thread safety in this instance.
Apr 5, 2012 at 5:48 vote accept webnoob
Apr 5, 2012 at 5:48 comment added webnoob This gave me an idea about using an array to store all some small classes with the information in. I then use the ID of the sections in the Xml file as an index in that array. This will allow me to get the information without recursing the whole file as I just call the array index I am currently on. It's hard to explain but I have a good concept from this that will most likely use less resources than the database.
Apr 4, 2012 at 17:17 history answered Daniel B CC BY-SA 3.0