|
Nish Sivakumar wrote: The entire database is cached in-memory. The entire thing
Yep - in fact there are database systems that are designed to work in that mode. I am working on one: SAP HANA[^]
|
|
|
|
|
That sounds neat. So these in-memory databases, they would keep persisting to a more solid storage source periodically, correct?
|
|
|
|
|
I would assume so. Back many years ago, I worked on some VAX/VMS systems where we had files mapped to memory for performance. Periodically, they would be 'flushed' back to the drives.
It wasn't as robust as a database system, but the concept was the same. The systems we used were integrated and could recover from a unexpected outage where data was lost.
|
|
|
|
|
SQL server added optimized in memory tables for SQL 2014. SQL server ends up generating C code, and then fires up a compiler behind the scenes to generate the access and indexing code. That's probably a step beyond what stack overflow is doing, but the performance improvement can be huge, especially switching from disk optimized data structures like b-trees to hash tables. It's not necessarily about the storage, but the optimizations you can do knowing that you never have to hit disk for a lookup.
edit, added a link: http://msdn.microsoft.com/en-us/library/dn133165.aspx[^]
|
|
|
|
|
Cool - interesting stuff there!
|
|
|
|
|
Nish Sivakumar wrote: So these in-memory databases, they would keep persisting to a more solid storage
source periodically, correct?
Correct. Here is the architecture of SAP HANA[^] and you can see the Persistence layer which is responsible for (re)storing data to and from disk.
|
|
|
|
|
|
ME: Wanna see Guardians of the Galaxy on August 2nd?
WIFE: What is it about?
ME: Uhhh... it is... uh... it is set in 19th Century England and it is a story about class struggle... and ... er.. .love and it stars, eh... Nicole Kidman, Hugh Grant and it is directed by Kenneth Branagh.
WIFE: Sure, I'll go.
|
|
|
|
|
MehGerbil wrote: August 2nd
Headlines Aug 3rd
A man was brutally slain by his enraged wife when she discovered that he lied to her about the movie being a chick flick. Film at 11.
|
|
|
|
|
|
Oddly enough, that news report sounds more interesting then the movies she drags me to...
|
|
|
|
|
You not none of these people who feel agoraphobic when you are not in the dog box..
|
|
|
|
|
If your wife is smart, she'll just smile and wait. The time will come when she takes you to a movie, taking away all sharp instruments and rope and make you sit through it. Something like Twilight, only worse.
|
|
|
|
|
Pay back is a bitch.
Once you lose your pride the rest is easy.
I would agree with you but then we both would be wrong.
The report of my death was an exaggeration - Mark Twain
Simply Elegant Designs JimmyRopes Designs
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
That's one of the more useful things you learn in the military: The ability to sleep in any place, position or situation. Bonus points for loud snoring.
The language is JavaScript. that of Mordor, which I will not utter here
I hold an A-7 computer expert classification, Commodore. I'm well acquainted with Dr. Daystrom's theories and discoveries. The basic design of all our ship's computers are JavaScript.
|
|
|
|
|
When I'm tired I can sleep anywhere. Anywhere but bed.
I have slept in a nightclub - took clients there and they were quite happy with the local seamstresses.
Planes I can be out before the safety announcement.
|
|
|
|
|
Something worse than Twilight?
You are in a dark place, my friend.
|
|
|
|
|
MehGerbil wrote: ME: Uhhh... it is... uh... it is set in 19th Century England and it is a story about class struggle... and ... er.. .love and it stars, eh... Nicole Kidman, Hugh Grant and it is directed by Kenneth Branagh.
WIFE: Sure, I'll go.
You will end up paying for this in many ways.
Don't expect an amorous evening when you get home, or for some time after that.
Once you lose your pride the rest is easy.
I would agree with you but then we both would be wrong.
The report of my death was an exaggeration - Mark Twain
Simply Elegant Designs JimmyRopes Designs
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
JimmyRopes wrote: Don't expect an amorous evening when you get home Yes, let's all pretend that was a possibility...
|
|
|
|
|
Signature construction in progress. Sorry for the inconvenience.
Damn you have the perfect signature - CBadger
|
|
|
|
|
Post from future:
He was a good man. It is sad he chose the wrong path of messing up with wife.
|
|
|
|
|
|
I won't try to convince your CEO on the basis of an undocumented big prize.
THESE PEOPLE REALLY BOTHER ME!! How can they know what you should do without knowing what you want done?!?!
-- C++ FQA Lite
|
|
|
|
|
Via my father I'm connected to the Agnelli family - so I may produce you a nice - framed - picture of a classic fiat model
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Man up. You're getting paid.
You'll never get very far if all you do is follow instructions.
|
|
|
|