You are right Les. I was afraid that such reply may come..... If file i/o was working fast everybody would do that rather then clustering with lots of RAM.
Thanks, -Michael On Sep 21, 5:48 am, Les Mikesell <[email protected]> wrote: > 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]
