problem about rdms-Collection of common programming errors

12 years ago
admin
1 minute

  • Andrew Harry
    c#-4.0 memory-mapped-files rdms
    I’m interested in people’s thoughts comparing storing data in a traditional SQL based Database or utilising a Memory-Mapped File such as the one in the new .Net 4.0 runtime. The data in question would be arrays of simple structures.Obvious pros and cons:SQL Database ProsAdhoc query support SQL Management Tools Schema changes (adding more columns and setting default values)Memory-Mapped ProsLighter overhead? (this is an assumption on my part) Shareable between process threads Any others?Is it wo

  • Andrew Orsich
    database memory mongodb redis rdms
    What database can you recomend for such case:Very lot of inserts and updates Sophisticated queries (SQL or something like it) Lot of data, but small amount of frequently accessed (can be in memory) It’s OK to loose part of data (recent hour for example) in case of crash (but not everything)Possible solutions and problems with it:Redis – looks good, but it doesn’t support complex queries. RDBMS (current solution) – guarantee ACID and use hard disc a lot so updates is too slow RDBMS + RAM disc –

Web site is in building