.Net 4.0 Memory-Mapped Files verses RDMS Storage

Posted by Harry on Stack Overflow See other posts from Stack Overflow or by Harry
Published on 2009-10-30T00:02:50Z Indexed on 2010/05/26 15:21 UTC
Read the original article Hit count: 270

Filed under:

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 Pros

Adhoc query support
SQL Management Tools
Schema changes (adding more columns and setting default values)

Memory-Mapped Pros

Lighter overhead? (this is an assumption on my part)
Shareable between process threads
Any others?

Is it worth it for performance gains?

Related posts about memory-mapped-files

Monitoring Windows Memory Mapped Files

as seen on Stack Overflow - Search for 'Stack Overflow'
In Windows, how can I keep track of the file mapping objects created by CreateFileMapping()? Basically I want to know how many memory mapped files are in use and the information like their names, sizes, etc. Thanks! >>> More
Memory Mapped Files .NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a project and it needs to access a large amount of proprietary data in ASP.NET. This was done on the Linux/PHP by loading the data in shared memory. I was wondering if trying to use Memory Mapped Files would be the way to go, or if there is a better way with better .NET support. I was thinking… >>> More
.Net 4.0 Memory-Mapped Files verses RDMS Storage

as seen on Stack Overflow - Search for 'Stack Overflow'
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 Pros Adhoc query support SQL… >>> More
Memory mapped files causes low physical memory

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a 2GB RAM and running a memory intensive application and going to low available physical memory state and system is not responding to user actions, like opening any application or menu invocation etc. How do I trigger or tell the system to swap the memory to pagefile and free physical memory… >>> More
Java memory mapped files and swap

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking at some memory mapped files in Java. Let's say I have a heap size set to 2gb, and I memory map a file that is 50gb - far more than the physical memory on the machine. The OS will cache parts of that 50gb file in the os file cache, the java process will have 2gb of heap space. What I'm… >>> More

Developer IT

.Net 4.0 Memory-Mapped Files verses RDMS Storage - Developer IT

.Net 4.0 Memory-Mapped Files verses RDMS Storage

c#4.0

memory-mapped-files

rdms

Related posts about c#4.0

What C# 4.0 language features can be used while targeting .NET 2.0?

Can I delete libc-bin?

Related posts about memory-mapped-files

Monitoring Windows Memory Mapped Files

Memory Mapped Files .NET

.Net 4.0 Memory-Mapped Files verses RDMS Storage

Memory mapped files causes low physical memory

Java memory mapped files and swap

Categories cloud