On 9/21/10 1:26 AM, MikeG. wrote:
Sorry I used blob to describe the final deliverable bundle not DB
blob.
As far as having partial objects in memory - this should never
happened based on my
intended design.
I would like to have the entire DB permanently in cache. Since I don't
have that much RAM on one machine
I plan to use virtual memory or memory mapped files. In this case my
only limit is as big as
my hard drive I'll get.
Why do you expect the file activity of virtual memory to be any faster than a
traditional database designed to use files efficiently? I'd expect the
opposite. You should generally assume that the disk head is going to be halfway
across the disk from the data you want and add up the seek time it will take to
get there. On the other hand, using real memory across several machines is very
fast.
--
Les Mikesell
[email protected]
