database - Data model for a C# winform application -
i'm writing winform program following data model:
- the data structure described set of class , subclass
- once store data, i'm serializing class xml file.
when software running data must accessed fast (the data model accessed between 50 , 60 per second.
i plan move data storage xml file lite database.
my question following: realistic use database not storage, during program execution? face loss of performance?
if don't need update data regularly, read it, best keep in memory.
we know little app, cannot give better advice here. maybe in case enough keep xml in xpathdocument structure, can perform fast searches using xpath queries.
another option be, if data key/value pairs, read xml dictionary , search dictionary in app.
but reading database, light one, hardly faster. counter-case can think of read-optimized fast nosql-db such mongodb. money on in-memory data structure optimized searching.
Comments
Post a Comment