Re: [Virtuoso-users] Complete DB in RAM

2017-07-04 Thread Jerven Tjalling Bolleman
Hi Henrik, I have thought about this as well. One way to be sure is roughly this recipe. First turn off swap! mkdir my_ram_disk#needs a directory mount -t tmpfs -o size=50G tmpfs my_ram_disk #50G in size cp existing virtuoso.db files etcc to my_ram_disk make a new v

[Virtuoso-users] Complete DB in RAM

2017-07-04 Thread Henrik Schmidt
Hi, we have a database of about 850mio triples, the file virtuoso.tx is about 50GB size on disk. While our application will only do SELECT queries. What is the best configuration to keep the complete set in RAM so no disk reads apart from the initial caching is needed ? How can we configure thi